[Etta]

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.

[Doug Robbins - Word MVP]

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.