Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with non-unique records
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with non-unique records
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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with non-unique records
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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with non-unique records
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutliple Records for each document in mail merge | Mailmerge | |||
Saving Mail Merge Records & also printing them. | Mailmerge | |||
skipped mail merge records | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
How to Mail merge records into a new/separate document | Mailmerge |