How to copy column of email addresses and paste directly to addr

's Computer Specifications

I want to copy a column from an excel sheet and paste it directly to the
address on an email.... How do I make the tthe semicolons appear?

's Computer Specifications

What happened when you tried it? What e-mail program are you using?

A program like Outlook is smart enough to put the separator in by itself.
You just copy the column and paste it in the "To:" box.

Another option is to add the semi-colon in Excel. In another column, use:
=a1&";"
Copy this down
Now copy and paste this column into the e-mail.

Regards,
Fred

"Mrs. Mc" <Mrs. (E-Mail Removed)> wrote in message
news:333BE5E2-983A-4C5D-BDF3-(E-Mail Removed)...
>I want to copy a column from an excel sheet and paste it directly to the
> address on an email.... How do I make the tthe semicolons appear?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
can I copy a column of email addresses, paste into email address?	=?Utf-8?B?TGl6aXpmcmVl?=	Microsoft Excel New Users	5	17th Jan 2012 05:16 PM
how do you copy& paste email addr instead of name assigned to add	=?Utf-8?B?YWdncmF2YXRlZA==?=	Microsoft Outlook Discussion	1	19th Jul 2007 03:01 AM
How do I cut and paste a column of email addresses into an email distribution list?	Colin	Microsoft Excel Misc	2	6th Oct 2004 08:27 PM
Can you copy email addresses in to new column out of Hyperlink column	=?Utf-8?B?UE0=?=	Microsoft Excel Misc	7	10th Mar 2004 05:20 AM
Copy email addr. in Hyperlink in to new column	=?Utf-8?B?UE0=?=	Microsoft Access Reports	0	21st Feb 2004 04:56 AM