View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TraciAnn TraciAnn is offline
external usenet poster
 
Posts: 1
Default Email merge a unique list to each recipient

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

,Orange Team
,Blue Team
,Orange Team
,Blue Team
,Orange Team
,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,
Julie,


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

What is needed to accomplish this?

--
---
TraciAnn

Message posted via
http://www.officekb.com