Using multiple recipients for one message in Merge

[ThomasOtte]

Dear all,

Situation:

I want to send 30 emails.
I use MS Excel as a database to fill the fields in my template message.


Fields are: First name, sex, content message, email address

Some of the 30 messages have to go to 1 recipient.
Others have to go to 2 recipients.

I have tried to add a second email address to the column "email address" in MS Excel with a semicolon, e.g. "john@123.com; sarah@123.com".
When finalising the Merge in MS Word, this produces an error. I am informed that Outlook "does not recognize john@123.com; sarah@123.com as an email address.

Can you maybe help me with this issue, either by directing me to an existing thread or by giving me instructions how to solve this problem?

Many thanks in advance, I hope the situation is clearly phrased like this.

Best,
Thomas

[macropod]

You can't use multiple email addresses for the recipient field in a merge to email. Instead, might drive the process via a macro that automates Outlook. For an example of such code, see:
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
You can modify that as described at:
http://www.wordbanter.com/showthread.php?t=58331

[gmayor]

You might consider http://www.gmayor.com/ManyToOne.htm which while not a true mail merge, will emulate one and you can merge the same message to multiple recipients. From your description you probably need the one to one merge to e-mail option.