If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create an Outlook distribution list from an Excel column
I have a column in Excel of about 1600 e-mail addresses. I would like to put
each of these addresses in the BCC field of an Outlook 2003 e-mail. Since I'm not running Exchange Server, I'm assuming this is the only way I can send a mass e-mailing to our customers without the customers seeing other customers' e-mail addresses. If it can be done by creating a distribution list, that would be fine too. Thank you. |
#2
|
|||
|
|||
if the addresses are in column A for example, try putting the formula =A1&";"
in the column next to it, copying that formula down the length of your data, then copying the results onto your clipboard and pasting into the BCC field. -Eddie O "Mike Officer" wrote: I have a column in Excel of about 1600 e-mail addresses. I would like to put each of these addresses in the BCC field of an Outlook 2003 e-mail. Since I'm not running Exchange Server, I'm assuming this is the only way I can send a mass e-mailing to our customers without the customers seeing other customers' e-mail addresses. If it can be done by creating a distribution list, that would be fine too. Thank you. |
#3
|
|||
|
|||
Awesome! Thank you!
"Eddie O" wrote: if the addresses are in column A for example, try putting the formula =A1&";" in the column next to it, copying that formula down the length of your data, then copying the results onto your clipboard and pasting into the BCC field. -Eddie O "Mike Officer" wrote: I have a column in Excel of about 1600 e-mail addresses. I would like to put each of these addresses in the BCC field of an Outlook 2003 e-mail. Since I'm not running Exchange Server, I'm assuming this is the only way I can send a mass e-mailing to our customers without the customers seeing other customers' e-mail addresses. If it can be done by creating a distribution list, that would be fine too. Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2003 Distribution List Problem/Question | itz nin | General Discussion | 3 | May 26th, 2005 09:52 PM |
How restore accidentally deleted Outlook distribution list?!? | sqh | General Discussion | 1 | May 13th, 2005 06:11 PM |
Create Distribution List from Contacts Imported from Excel | Duncan Lally | Contacts | 0 | February 14th, 2005 09:02 AM |
E-mail Display name is wrong | Jane Nangle | Contacts | 9 | February 4th, 2005 10:05 AM |
Import Outlook 2003 distribution list to mail merger recipents list | xfile | Mailmerge | 3 | January 25th, 2005 07:16 PM |