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?

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 Articles

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


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


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

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

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?

"Doug Robbins - Word MVP" wrote:

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 Articles

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


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


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

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

Which method are you using?

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

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

"Doug Robbins - Word MVP" wrote:

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 Articles

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


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


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

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