mail merge with non-unique records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tjb - 12 Dec 2005 16:58 GMT

I have an excel file that is laid out as follows:

Doe John 123456789 Jimmy Doe
Doe John 123456789 Jack Doe
Doe John 123456789 Mary Doe
Doe Jane 987654321 Brian Doe
Doe Jane 987654321 Timmy Doe

For each time John Doe is listed I want Jimmy, Jack and Mary to show on the
mail merge document. The mail merge document would look something like this:

Dear John Doe:
We haven't received information on the following individuals:
Jimmy Doe
Jack Doe
Mary Doe
Thanks for your prompt attention.

Will the layout of the file work for this?

Reply to this Message

Doug Robbins - Word MVP - 12 Dec 2005 19:06 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 Articles

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

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

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 have an excel file that is laid out as follows:
>
[quoted text clipped - 17 lines]
>
> Will the layout of the file work for this?

Reply to this Message

tjb - 12 Dec 2005 22:45 GMT

I've been working on this for hours and I still cannot get it to work. I'm
understanding the logic behind what's happening with the key fields but it's
just not doing what I want. Any suggestions?

> You are trying to perform a "multiple items per condition (=key field)"
> mailmerge which Word does not really have the ability to do:
[quoted text clipped - 31 lines]
> >
> > Will the layout of the file work for this?

Reply to this Message

Doug Robbins - Word MVP - 13 Dec 2005 05:30 GMT

Which method are you using?

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've been working on this for hours and I still cannot get it to work.
> I'm
[quoted text clipped - 37 lines]
>> >
>> > Will the layout of the file work for this?

Reply to this Message

Rate this thread: