personalized email to multiple addrs thru email merge

[Citywoman]

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

 

[Lanwench [MVP - Exchange]]

In

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

Unless I've misunderstood, I'm not sure what the point would be here ...each
recipient with multiple addresses would receive multiple e-mail messages
anyway, so why not just use mail merge the way it works now, and send a
single message to each recipient address? I don't think you can use mail
merge to send to multiple recipients in a single message - that's what it's
designed *not* to do.

Note that Outlook isn't the best mass mailing option out there - if you need
to do regular mass mailings, you might look into a proper listserv
application like Lyris, or an outside service that will do this for you and
manage bounces/subscribe/unsubscribe requests.

 

[Citywoman]

I'm in a time crunch and using this as a tool to send out wedding e-invites.
I have husband and wife email addresses in one Outlook contact; sending the
same personalized email, e.g. To Mr and Mrs John Doe, to both the husband
and the wife ensures someone will see it! Plus, it keeps me from having to
pick which one to direct the email to. Since this is a onetime deal, I
didn't want to use a listserv.

Do you have any hints for work-arounds similar to postings about being able
to attach a file in a e-mail merge?

Thank you.


"Lanwench [MVP - Exchange]"

 

[Lanwench [MVP - Exchange]]

In

I'm in a time crunch and using this as a tool to send out wedding
e-invites. I have husband and wife email addresses in one Outlook
contact; sending the same personalized email, e.g. To Mr and Mrs John
Doe, to both the husband and the wife ensures someone will see it!

Hmm - not sure how to deal with that.

Plus, it keeps me from having to pick which one to direct the email
to. Since this is a onetime deal, I didn't want to use a listserv.

I suppose there's evite.com , as one option....but of course you'd have to
get all the addresses pasted into there.

Do you have any hints for work-arounds similar to postings about
being able to attach a file in a e-mail merge?

You can't do this with mail merge - might want to search for "mass mail" at
www.slipstick.com

Thank you.


"Lanwench [MVP - Exchange]"

In

Unless I've misunderstood, I'm not sure what the point would be here
...each recipient with multiple addresses would receive multiple
e-mail messages anyway, so why not just use mail merge the way it
works now, and send a single message to each recipient address? I
don't think you can use mail merge to send to multiple recipients in
a single message - that's what it's designed *not* to do.

Note that Outlook isn't the best mass mailing option out there - if
you need to do regular mass mailings, you might look into a proper
listserv application like Lyris, or an outside service that will do
this for you and manage bounces/subscribe/unsubscribe requests.