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 / February 2006

Tip: Looking for answers? Try searching our database.

personalized email to multiple addrs thru email merge?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Citywoman - 04 Feb 2006 20:21 GMT
Is there a way to send a personalized email to more than one recipient,
where the email is generated through a mail merge? In other words, have more
than one email adress in the "To" field for each personalized email?

I have more than one email address for some people. I want to use email
merge to generate personalized emails from one outlook entry (exported to
one row in an Excel sheet) that will go to each of their email addresses.

I tried using a field I created in Excel that had each of their email
addresses, separated by semicolons, in one cell. I tried using that cell as
the addressing field, but Outlook didn't like it. I tried using commas as
separators also, but Outlook didn't like that either!  The email ends up in
the Draft folder, with no email address in it at all!

I don't want to create a separate row, for each person that has more than
one - that's too much work cause I have to do about 300 personalized emails!

Please help....
Doug Robbins - Word MVP - 04 Feb 2006 21:28 GMT
Using mailmerge, it is only possible to send to one address per record.

Using VBA and the Outlook Object model amongst other things, you could send
it to more than one address, but for a once off situation, unless you are
really into Visual Basic, creating multiple records for each email address
is going to be the easiest way.

Signature

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

> Is there a way to send a personalized email to more than one recipient,
> where the email is generated through a mail merge? In other words, have
[quoted text clipped - 18 lines]
>
> Please help....
 
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.