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.