Mail Merge with Multiple rows from Access for email

[jared]

Hi,

I would appreciate any assistance on how to create a
mail merge with muliple rows from ACCESS for the
same customer. The mail merge needs to be emailed, so a
catalog mail merge is not helpful.

Access Data Sheet contains:
Customer Name No Product
Blue light 1 Pencil
Blue light 1 Mouse
Blue light 2 Biro
Smith Jones 3 Calculator
Smith Jones 3 Book

I want the mail merge document to look like this:

Letter 1:
Customer Name
Address

Dear Sir/Madam

You have purchased the following

1 Pencil
1 Mouse
2 Biro

Yours sincerely..

Letter 2:
Customer Name
Address

Dear Sir/Madam

You have purchased the following

3 Calculator
3 Book

Thank you for all of your help!

 

[Cindy Meister -WordMVP-]

Hi Jared,

I would appreciate any assistance on how to create a
mail merge with muliple rows from ACCESS for the
same customer.

Start by looking under "Special merges" in the mail merge
FAQ on my website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail