Mail merge from subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

diddion - 02 Apr 2006 20:54 GMT

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

--
diddion

Reply to this Message

Doug Robbins - Word MVP - 03 Apr 2006 07:59 GMT

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

Signature

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

> I am trying to mailmerge from Access 2000 into Word, where the Access
> database includes a number of sub tables. For example, the database
[quoted text clipped - 6 lines]
> to do on the final document, so I don't think the Access report route
> would be suitable. Thanks!

Reply to this Message

diddion - 03 Apr 2006 16:45 GMT

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

Signature

diddion

Reply to this Message