Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Omit duplicate contacts, but include selected data for those omitt
My issue is two-fold. I am using Office 2003, specifically Word for the
merged letter and an existing Excel spreadsheet for the data. I have a list of 1000 participants for a sports event. I want to send a confirmation letter to the participants' coaches, listing their students and the event for which they are entered. Many coaches have multiple students, resulting in duplicated merged letters. In performing the merge, If I deselect the duplicated entries for a coach, I will be omitting the other required data, namely their other students. Perhaps my example would help... I want ONE letter addresssed to COACH #1 to include a complete list of his 10 registered particpants. Beside each name, I want to include the event category and time of the event, all of which are recorded in the Excel spreadsheet. All required data is on a single line in the spreadsheet for each participant. Can this be done in a single step? Or do I have to manually cut-and-paste the data from each additional merged letter into a single letter? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E-mail merge used addresses NOT in selected Outlook Contacts folde | Mailmerge | |||
Mail Merge and Outlook Contacts | Mailmerge | |||
multiple docs, one data source | Mailmerge |