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?