Reply
 
Thread Tools Display Modes
  #1   Report Post  
otisg1
 
Posts: n/a
Default Conditional merging of records

I have an Access query that is the data source for the merge. There is a
record for each individual resident of a unit. I would like to merge these
records into a letter so that all the residents of a particular unit would
appear on each letter. There is a control field in the query that could be
checked. Is this possible?
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

You should use a report in Access to do this. Word does not really have the
ability to perform a "multiple items per condition (=key field)" mailmerge.

You might take a look the "Multiple items per condition" item under the
"Special merges" section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindy...r/MergFram.htm

but you are going to be better off to use an Access report.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"otisg1" wrote in message
...
I have an Access query that is the data source for the merge. There is a
record for each individual resident of a unit. I would like to merge these
records into a letter so that all the residents of a particular unit would
appear on each letter. There is a control field in the query that could be
checked. Is this possible?



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
missing records capcamp Mailmerge 1 February 1st 05 01:31 AM
Problems merging many records on a single page Carl Mercier Mailmerge 1 January 16th 05 12:27 AM
merging 1400 dbase records with word; saving doc MarkB Mailmerge 2 December 18th 04 07:40 AM
Merging data from two consecutive access records in Word 2002 Frank Spade Mailmerge 3 December 17th 04 09:51 AM
Does anyone know how to include blank records from an Excel datab. Sandy Rung Microsoft Word Help 1 November 30th 04 06:33 PM


All times are GMT +1. The time now is 06:07 PM.

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

About Us

"It's about Microsoft Word"