Conditional merging of records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

otisg1 - 16 Feb 2005 13:43 GMT

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 to this Message

Doug Robbins - 16 Feb 2005 23:58 GMT

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.

Signature

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

>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 to this Message