Combine records in mail merge

[kenaruj]

How do you get multiple records to appear on the same letter? For example, customers w/ 1 or more orders. Sending a letter to the customer with a few details of each order (#, date, amount). I have a list with the necessary data, just need to put it into the form letter.

I am using Word 2007.

Also, are there any advanced Word tutorials out there?

Thanks

 

[SkipVought]

Hi,

You could do this quite easily in Excel, using the Data > Auto Filter feature, to display one customer's data at a time.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[PeterMoran]

Hi,

This is not any easy problem.

Here are some references:

http://support.microsoft.com/?kbid=105888

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg

You will find Cindy Meister's website most useful for Mail Merges.

Good Luck!

Peter Moran