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