Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2004

Tip: Looking for answers? Try searching our database.

Mail Merge to email using Word 2000

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rich2818 - 10 Nov 2004 01:24 GMT
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).
Doug Robbins - 10 Nov 2004 04:10 GMT
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.

Signature

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

>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).

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.