Email merge a unique list to each recipient

T

TraciAnn

Word '07

I do an email merge using an Excel data source. The data source lists people,
their contact information and their Team.

I need to create a merged email to each record and include a list of their
team.

So If I have a list:
Column A = Name
Column B = Email
Column C = Team

Tom,[email protected],Orange Team
Sally,[email protected],Blue Team
Harry,[email protected],Orange Team
Jane,[email protected],Blue Team
Julie,[email protected],Orange Team
Fred,[email protected],Blue Team

I need to send an email such as:
=================
<Name>:

Team assignments have been made. You have been assigned to <Team>. The other
members of your team and their contact information is:

<Name>, <email>
<NextRecord>
=================


Resulting in:
=================
Tom:

Team assignments have been made. You have been assigned to Orange Team. The
other members of your team and their contact information is:

Harry, (e-mail address removed)
Julie, (e-mail address removed)

=================

What is needed to accomplish this?
 

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