Complex Merge - multirow data from Access to go to Word mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Redrabbit - 03 Jun 2004 21:11 GMT

I have an Access database that I want to use in a Mail Merge to Word.

For a letter, I want to pull in all names & addresses for a given KEY....and put MULTIPLE names/addresses on ONE letter
(I have to put a maximum of 3 name/addresses (or row data) on one letter; I will have to print up to 3 copies of the letter & change the addressee for each letter.

When the Key changes, I want to start a new letter. Is there a way to do this in Access/Word with Merge?? HELP!!
Time Crunch here, advice appreciated !

Reply to this Message

Doug Robbins - Word MVP - 03 Jun 2004 23:07 GMT

See 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

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have an Access database that I want to use in a Mail Merge to Word.
>
> For a letter, I want to pull in all names & addresses for a given KEY....and put MULTIPLE names/addresses on ONE letter.
> (I have to put a maximum of 3 name/addresses (or row data) on one letter; I will have to print up to 3 copies of the letter & change the addressee for

each letter.)

> When the Key changes, I want to start a new letter. Is there a way to do this in Access/Word with Merge?? HELP!!!
> Time Crunch here, advice appreciated !!

Reply to this Message