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.

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/cindy...faq1.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...b;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

"yuckster" wrote in message
...
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.