Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Citywoman
 
Posts: n/a
Default personalized email to multiple addrs thru email merge?

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

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default personalized email to multiple addrs thru email merge?

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.

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

"Citywoman" wrote in message
...
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....



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending Mail Merge to Email to Multiple Recipients in the Same Mes Mark V Mailmerge 13 April 21st 23 05:06 PM
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
sending email merge to multiple recipients in same message? Mikhail Mailmerge 1 November 18th 05 04:58 AM
Multiple merge with IncludeText generating extraneous hidden chara Judy Mailmerge 4 May 5th 05 03:51 PM
Using MAILMERGE fields within HYPERLINK fields for Merge to Email Mark V Mailmerge 2 December 4th 04 04:01 PM


All times are GMT +1. The time now is 08:37 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"