Mutiple data names for Mail Merge

[Kathy Tyler]

Hi,

I would like appreciate any assistance on how to create a
mail merge with muliple data in the excel field for the
same customer to one letter.

Excel 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

Yours sincerely..


Cheers Kathy

 

[Graham Mayor]

See Cindy's web site on special merges
http://homepage.swissonline.net/cindymeister/mergfaq1.htm#ComplexMerg

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>