Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging one document with two lists
Is there a way to merge one document with two data sources at the same time?
Or do you have suggestions on how to solve the following problem? I have a Word document (Cover Sheet) that needs to merge with two separate data sources. The Cover Sheet has a title bar containing a Form's Title and Form Number, as well as a table containing ten rows into which a series of numbers need to be merged. I have one source document that contains a list of forms and their form numbers, and a second source document that contains fields for series of control numbers -- Control#1, Control#2, Control#3, Control#4, Control#5, Control#6, Control#7, Control#8, Control#9, Control#10. Ultimately, the merged Cover Sheet would contain a unique Form Title and Form Number in the title bar and control numbers in the table (ex. 00001 through 000010). Your suggestions will be greatly appreciated. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging one document with two lists
Word can only use a single, flat data source for mail merge.
Sounds like 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 or at: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Etta" wrote in message ... Is there a way to merge one document with two data sources at the same time? Or do you have suggestions on how to solve the following problem? I have a Word document (Cover Sheet) that needs to merge with two separate data sources. The Cover Sheet has a title bar containing a Form's Title and Form Number, as well as a table containing ten rows into which a series of numbers need to be merged. I have one source document that contains a list of forms and their form numbers, and a second source document that contains fields for series of control numbers -- Control#1, Control#2, Control#3, Control#4, Control#5, Control#6, Control#7, Control#8, Control#9, Control#10. Ultimately, the merged Cover Sheet would contain a unique Form Title and Form Number in the title bar and control numbers in the table (ex. 00001 through 000010). Your suggestions will be greatly appreciated. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Outline Numbered Lists in One Document | Microsoft Word Help | |||
how many lists can I insert in a word document? | Microsoft Word Help | |||
Can I use multiple lists when merging | Mailmerge | |||
Merging to New Document | Mailmerge | |||
Document map displays lists and bold lines | Microsoft Word Help |