Multiple Records Mail Merge

[Guest]

I have an excel spreadsheet containing data for mail merge. Each record in a
row lists customer name and account number. I am trying to send letter to
each customer with a list of account numbers. To do this I need to be able to
group records by name and then list account numbers on one letter. Not sure
if there is any way to accomplish this.

 

[Doug Robbins - Word MVP]

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

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

Or take a look at the following Knowledge Base Article

How to Work Around Duplicate Names in Mail Merge Data

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP