I'm trying to create letters to parents that include their child's name and
the grades for all of their classes. The grades are in an Access database
query. Each record contains ParentName, ChildName, Class and Grade. Since
each child takes several classes, there are multiple records for each of the
hundreds of children in the database. If I do a regular mail merge, it
generates a letter for each class/grade resulting in 5 or 6 letters per child
instead of one. How do I create a list of grades in the each letter?

Cindy Meister has the only answer I'm aware of:
http://homepage.swissonline.ch/cindy...tm#ComplexMerg
************
Anne Troy
www.OfficeArticles.com

"MarleneC" wrote in message
...
I'm trying to create letters to parents that include their child's name
and
the grades for all of their classes. The grades are in an Access database
query. Each record contains ParentName, ChildName, Class and Grade.
Since
each child takes several classes, there are multiple records for each of
the
hundreds of children in the database. If I do a regular mail merge, it
generates a letter for each class/grade resulting in 5 or 6 letters per
child
instead of one. How do I create a list of grades in the each letter?

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

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 Article

How to Work Around Duplicate Names in Mail Merge Data

http://support.microsoft.com/default...b;en-us;302665


--
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
"MarleneC" wrote in message
...
I'm trying to create letters to parents that include their child's name
and
the grades for all of their classes. The grades are in an Access database
query. Each record contains ParentName, ChildName, Class and Grade.
Since
each child takes several classes, there are multiple records for each of
the
hundreds of children in the database. If I do a regular mail merge, it
generates a letter for each class/grade resulting in 5 or 6 letters per
child
instead of one. How do I create a list of grades in the each letter?