Merging multiple records onto one letter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick Fritzler - 17 Oct 2003 19:11 GMT

I am trying to create warranty letters to send out to
customers. I have Office XP, and my data is stored in an
MS Access table. The table is full of customers and what
they purchased. There are duplicate records in the table
because I need to list all of their purchases on the
warranty letter. However, I can not figure out how to get
each customers purchases to list out on the letter. I get
a letter for each product they purchases. I want every
product on one page. Can anyone give me some pointers?
Thank you.

Reply to this Message

Doug Robbins - Word MVP - 18 Oct 2003 09:01 GMT

Hi Nick,

It's far easier to do this with a report in Access than to use Word, but if
you must do it in Word, 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 am trying to create warranty letters to send out to
> customers. I have Office XP, and my data is stored in an
[quoted text clipped - 6 lines]
> product on one page. Can anyone give me some pointers?
> Thank you.

Reply to this Message