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

[Redrabbit]

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 !

 

[Doug Robbins - Word MVP]

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


--
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!!!