Merge Multiple Records from Excel into Word Mail Merge

[Jim]

Is this possible?

I have an Excel spreadsheet that has all the employees at a certain
store. Each employee is listed in an individual row in the
spreadsheet, and they all have the same eMail address, such as
(e-mail address removed).

I want to create a eMail merge from Word that automatically is
addressed to (e-mail address removed) (which I know how to do), but I
want the eMail to have all the names of the employees at the store
listed in the body of the eMail, such as would be shown below:

Dear (e-mail address removed)

Your store employees are:
John Smith
Jane Doe
Susan Jones
Sam Walsh
Steven Raymond

Right now, I can figure out how to send off the 5 individual eMails,
but I want to have all the employees on a single eMail so I don't
bring down our system.

Thoughts?

 

[Doug Robbins - Word MVP]

It's not going to do everything that you want as you would have to manually
send the email, but take a look at:

http://cornell.veplan.net/article.aspx?&a=3815

or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP