If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Email merge a unique list to each recipient
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 |
Thread Tools | |
Display Modes | |
|
|