| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy column of email addresses and paste directly to addr
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy column of email addresses and paste directly to addr
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. wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from Excel & paste directly to Gmail - instead of as attachment | Excel Discussion (Misc queries) | |||
| Once I paste email addresses seperated only by comas into Excel h. | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
| Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions | |||
Linear Mode
