Merge w/varying amount of rows to repeat for each company

[cerri starr]

I am trying to make a mail merge document that will list multiple items for
one company in the letter. For example:

Company A Product 1
Company A Product 2
Company B Product 3
Company B Product 4
Company B Product 5

So, I want to send company A one letter with products 1 & 2 listed and I
want to send Company B one letter with products 3, 4 & 5 listed.

All I can figure out is how to repeat a set number of rows, which doesn't
work because the number of products varies for each company. Or how to make
a separate letter for each product, which I don't want to do, because I don't
want to send multiple letters to one company.

If anyone can please tell me how to accomplish this, I would be very grateful.

Thank you!

 

[Doug Robbins]

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 respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP