Conditional merging of records

[otisg1]

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?

 

[Doug Robbins]

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