Mail Merge to email using Word 2000

R

Rich2818

I am trying to create an email merge using an Excel data source. The email
addresses is a column in the Excel spreadsheet. I can only seem to send the
mail merge email to one email address only. How can you send to multiple
email addresses (either as multipe addresses on the To: line or To & Cc:
Line).
 
D

Doug Robbins

You would have to use a macro to do this. The one in the article "Mail
Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

would be a good starting point. You would need to do something similar as
far a creating a catalog type mailmerge document is concerned and then
iterate through that, picking up the email addresses from each row in the
catalog and using them with each document=section of the document that you
want to email.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top