Mail Merge with Outlook & Excel - multiple e-mail addresses

T

Tom @ PHS

I have an extensive .xls file with 1 column of data and 4 columns of
recipients' e-mail addresses. Have successfully inserted the data column
into the e-mail. Cannot determine how to actually get the e-mail addresses
into the Outlook "To" field.
 
D

Diane Poremsky [MVP]

you'll probably need to make 1 address per record - it might work to
concatenate the addresses into one cell, separated by semi colons - you can
do it fairly quickly with a formula, then copy and paste special as values
to remove the formula. Try that column in the merge - if it fails, you'll
need to go with 1 record per address.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
T

Tom @ PHS

Diane: Thank you. I moved the recipients to the first column of the
spreadsheet, and was untimately prompted to select values from that source
for entry into the "To" field. Only problem: Outlook can't find matches for
multiple recipients. Spreadsheet format:
Last1, First1 ; Last2, First2; ...Last#, First #
Error message: Microsoft Outlook does not recognize
"Last1, First1 ; Last2, First2; ...Last#, First #"
If you have used a comma to separate addresses; Click Cancel, replace the
commas with semicolons, and then click Send Again.
Note that quotes appear in the error message but not on the .xls.
Single recipients received their e-mails as intended.
 
Top