I am trying to mailmerge from Access 2000 into Word, where the Access
database includes a number of sub tables. For example, the database
includes a main table, with a client's personal details. It also
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 tables
for each client, each with a variable number of records). Is there any
way to encourage the merged document to include all records in the
related tables for that client? Incidentally, I do have some editing
to do on the final document, so I don't think the Access report route
would be suitable. Thanks!


--
diddion

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/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

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

or at:

http://www.knowhow.com/Guides/Compou...poundMerge.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" wrote in message
...

I am trying to mailmerge from Access 2000 into Word, where the Access
database includes a number of sub tables. For example, the database
includes a main table, with a client's personal details. It also
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 tables
for each client, each with a variable number of records). Is there any
way to encourage the merged document to include all records in the
related tables for that client? Incidentally, I do have some editing
to do on the final document, so I don't think the Access report route
would be suitable. Thanks!


--
diddion

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


--
diddion