Mail merge from subforms

[diddion]

I am trying to mailmerge from Access 2000 into Word, where the Acces
database includes a number of sub tables. For example, the databas
includes a main table, with a client's personal details. It als
includes a table with the names and dates of birth of their children
each one appearing as a single record (there are about ten such table
for each client, each with a variable number of records). Is there an
way to encourage the merged document to include all records in th
related tables for that client? Incidentally, I do have some editin
to do on the final document, so I don't think the Access report rout
would be suitable. Thanks

 

[Doug Robbins - Word MVP]

If it was me, I would do it all in Access, but

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm


--
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

 

[diddion]

Thanks for the reply. I'll give these a go and report back.