many to one mail merge with access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 18 Feb 2004 02:40 GMT

Can anyone tell me how to do a many to one mail merge with
an access database? Example: I have students that have
many course numbers in seperate records. Iwant to put all
of those into one word letter.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Feb 2004 07:45 GMT

The easiest way is to create the letter as a report in Access using
Grouping.

Word does not do it very well, but 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

> Can anyone tell me how to do a many to one mail merge with
> an access database? Example: I have students that have
> many course numbers in seperate records. Iwant to put all
> of those into one word letter.

Reply to this Message