Help please!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drolefille@gmail.com - 07 Feb 2006 15:01 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 07 Feb 2006 18:54 GMT

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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

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

Signature

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

> 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
[quoted text clipped - 5 lines]
> Thanks very much!
> ~Drolefille

Reply to this Message

drolefille@gmail.com - 07 Feb 2006 21:36 GMT

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.

Reply to this Message