Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
diddion
 
Posts: n/a
Default Mail merge from subforms


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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail merge from subforms

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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
diddion
 
Posts: n/a
Default Mail merge from subforms


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


--
diddion
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
NO CODE - mail merge to Outlook with attachment with CC BrianH Mailmerge 1 February 10th 10 02:53 PM
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th 06 05:43 AM
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 10:12 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"