Merging one document with two lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Etta - 06 Oct 2007 21:20 GMT

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 to this Message

Doug Robbins - Word MVP - 06 Oct 2007 22:00 GMT

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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

Signature

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

> Is there a way to merge one document with two data sources at the same
> time?
[quoted text clipped - 16 lines]
>
> Your suggestions will be greatly appreciated.

Reply to this Message