Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I include multiple database records in one letter?
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Records Same Page | Mailmerge | |||
Multiple records into a single document | Mailmerge | |||
How do I set up mail merge to include 2 separate sets of records . | Mailmerge | |||
How do I get multiple Access records into a single mailmerge lett. | Mailmerge | |||
Does anyone know how to include blank records from an Excel datab. | Microsoft Word Help |