MS Excel gurus...i need some help - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 4 (permalink) Old 01-15-2007, 02:14 PM Thread Starter
Time Served
 
Join Date: Feb 2001
Location: DFW
Posts: 228
MS Excel gurus...i need some help

Alright, I need some help with excel....I know there is an easy way to do this, just overlooking it....

I have a spreadsheet with a column of email addresses in Excel. is there an easy way to copy/format these so I can paste them into a "To" or "CC" section of an email.

If I just cut and paste them, my email doesn't like the fact that there aren't any commas separating them and I get a error message.

I know there has to be a way to do this without copy/paste each addy or re-typing them all in.....maybe to paste into word with special formatting or something???...or a way to add a comma after the text in each cell, then move them over???

Any help would be much appreciated.
svosam is offline  
Sponsored Links
Advertisement
 
post #2 of 4 (permalink) Old 01-15-2007, 03:42 PM
Lifer
 
bard's Avatar
 
Join Date: Aug 2000
Location: Prosper
Posts: 4,668
Hmm, I was just able to copy the cells in a column, paste into an email address 'To' field without a problem. They all stayed in a column until I tabbed out of it. I'm using XP Pro and Outlook.
bard is offline  
post #3 of 4 (permalink) Old 01-15-2007, 04:32 PM Thread Starter
Time Served
 
Join Date: Feb 2001
Location: DFW
Posts: 228
Hmmm, I'm not using outlook. when I paste, it will insert the column and then change to a list when I tab out, but is not putting any commas or semi-colons between addys....that is why I am getting the error message.

Is outlook adding the commas or at least recognizing that there are multiple email addresses? I only get the error when I hit the send key.

Thanks for you help.
svosam is offline  
 
post #4 of 4 (permalink) Old 01-15-2007, 05:14 PM
Lifer
 
bard's Avatar
 
Join Date: Aug 2000
Location: Prosper
Posts: 4,668
What if you transpose it first? (paste special)
bard is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome