Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Add related subform to mail merge document
I have mail merged a document into Word from an Access query. I now want to
add a subform that would typcially have several records for each one related record in the Word document. They are linked by StudentID. It is a one to many relationship. Can I identify another source for another merge for the subform? -- Col |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Add related subform to mail merge document
I would just use an Access Report for the whole thing. Word does not have
the ability to do it easily. See http://www.knowhow.com/Guides/Compou...poundMerge.htm Or "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 http://support.microsoft.com/default...b;en-us;211303 -- 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 "Carolyn M" wrote in message ... I have mail merged a document into Word from an Access query. I now want to add a subform that would typcially have several records for each one related record in the Word document. They are linked by StudentID. It is a one to many relationship. Can I identify another source for another merge for the subform? -- Col |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Add related subform to mail merge document
Thanks for your help. I am more familiar with Access and have done lots of
reports incuding adding subforms. Where I am struggling there is how to format the text boxes to a letter layout and inserting the necessary fields at the same time. I will pose my question of formatting to the Access people. Thanks again. -- Col "Doug Robbins - Word MVP" wrote: I would just use an Access Report for the whole thing. Word does not have the ability to do it easily. See http://www.knowhow.com/Guides/Compou...poundMerge.htm Or "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 http://support.microsoft.com/default...b;en-us;211303 -- 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 "Carolyn M" wrote in message ... I have mail merged a document into Word from an Access query. I now want to add a subform that would typcially have several records for each one related record in the Word document. They are linked by StudentID. It is a one to many relationship. Can I identify another source for another merge for the subform? -- Col |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
collate pages in mail merge vs mail merge being single document | Mailmerge | |||
Can I e-mail a mail merge document? | Mailmerge | |||
Mail Merge Errors1 document created after merge | Mailmerge | |||
I can't get a mail merge document to open, I get "the document na. | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge |