Hi TraciAnn,
You can use Word's Catalogue/Directory Mailmerge facility for this (the terminolgy depends on the Word version), followed by a
standard email merge. To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.
--
Cheers
macropod
[Microsoft MVP - Word]
"TraciAnn" u50702@uwe wrote in message news:965d2e9a7ee8f@uwe...
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