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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Omit duplicate contacts, but include selected data for those omitt
You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Dimtrax" wrote in message ... 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Omit duplicate contacts, but include selected data for those o
I have been to all three sites and can get this to work only as a directory.
Hoe do I get this to work in a merge letter? "Doug Robbins - Word MVP" wrote: You are trying to perform a "multiple items per condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Dimtrax" wrote in message ... 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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Omit duplicate contacts, but include selected data for those o
Basically, you can't - Not with mail merge. What is your data source? If
it is Access, I would use a report for it. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "RIC" wrote in message ... I have been to all three sites and can get this to work only as a directory. Hoe do I get this to work in a merge letter? "Doug Robbins - Word MVP" wrote: You are trying to perform a "multiple items per condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Dimtrax" wrote in message ... 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? |
Reply |
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 |