Email Merge to multiple recipients

S

Sean Roulet

I've successfully managed to email merge a long list.

I now need to merge data with mutiple recipients. For example my
merge file may look like this:

Event, School, Contacts
Summer Fair, Local School, (e-mail address removed) |
(e-mail address removed)


Obviously I could resolve this by making 2 separate lines for Joe and
Jane. however, I need to send the same information to both. After that
there will be another event for other people to receive.

How can I solve this?

Thanks
 
P

Peter Jamieson

As far as I know there is no simple way to include multiple recipients in
the same e-mail when using the built-in mail merge facilities.

You could probably do it by creating your own "merge" using VBA to process
each data source record and add the e-mail envelope.

So the approach of having one line per recipient is probably the simplest
one, and apart from the following problems I can't really see what
difference it makes:
a. each recipient does not see the other recipients listed in the to: and
so cannot usefully "Reply to all"
b. using multiple recipients per e-mail might reduce transmission time/cost

[A possible workaround for (a) might be to
1. send one email per recipient but
2. have two columns in your list. The first would contain the recipient,
and the second would contain the complete list of recipients for this e-mail
3. put a merge field with the complete recipient list in the body of your
mail merge main document.

It still wouldn't let people "Reply to All" but at least they copuld
copy/paste the complete list of recipients into their e-mail client, which
amounts to the same thing.]
 

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