I'm new to using mail merge (Word 2002) and I'm attempting to send a
form letter that will combine multiple accounts that are attached to
identical addresses. If John Doe has 3 accounts with us, I'd like him
only to get one letter with all these accounts, even if he's listed 3
times on my excel spreadsheet. Is this possible or am I just going to
have to restructure the spreadsheet?

Thanks very much!
~Drolefille

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

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

http://support.microsoft.com/default...b;en-us;211303


--
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

wrote in message
oups.com...
I'm new to using mail merge (Word 2002) and I'm attempting to send a
form letter that will combine multiple accounts that are attached to
identical addresses. If John Doe has 3 accounts with us, I'd like him
only to get one letter with all these accounts, even if he's listed 3
times on my excel spreadsheet. Is this possible or am I just going to
have to restructure the spreadsheet?

Thanks very much!
~Drolefille

Thanks a bunch. The instructions on the website seem a little out of
my league, but I have a few ideas for a work around on the spreadsheet
end of things.