Merging with Two Data Sources

by Allen Wyatt
(last updated December 27, 2013)

7

Minh asked if there is a way to do a merge of two data sources with a single merge document? Word allows you to merge a single data source with a merge document, but he couldn't find a way to merge more than one data source.

The reason you can't find the option is that it doesn't exist. Word doesn't provide a facility for multiple data sources. You can, however, do two separate merges, changing the data source between the two passes. Provided that the merge fields are the same in both data sources, you would end up with two merged documents created from each pass. You could then combine the two documents together via a simple copy and paste.

If you are looking for a way to include different merge fields from each of the different data sources, there is no way to accomplish that—at least that we've been able to find.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (3337) applies to Microsoft Word 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Automatically Adding Tabs in Footnotes

When you add a footnote to a document, Word's normal formatting adds a space after the footnote number and before the body of ...

Discover More

Numbers in Base 12

Different professions use numbers in entirely unique ways. You may need to come up with a number that represents the number ...

Discover More

Turning Off Insert Options

When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? Here's how to get ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (menu)

Using Unique Document Serial Numbers

If you need to include serial numbers in your printed matter (labels, letters, documents, etc.), the best way is through the ...

Discover More

Mail Merge and Data Source Documents become Unattached

When you create a mail merge document, you attach it to a data source that is the basis for the information to be merged with ...

Discover More

Conditionally Adding a Period in a Mail Merge

When merging data into a Word document, you may want to add information to the document based on an evaluation of what is ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 2?

2016-02-18 04:48:20

Anna

Hello,

What if I have my address list in one Excel document, but in case of a few addressees I need to use "the other correspondence address" from another column then the rest. If conditional formatting helps, so which one will apply: Excel's or Mail Merge's?

Many thanks.

Anna


2016-01-24 04:29:54

Ciro Rocha

I'm giving a try to subdocuments for this purpose. Subdocuments may host their own data sources, and therefore merge different reports.
I've spotted some weird outcomes though:
After creating subdocuments, word inserts many section breaks. I've just deleted them;
If we update all the fields in the master document, subdocument mergefields loose their connection. Subdocuments should be locked, so that no unintended changes are made.
But after closing and reopening the master document, the lock is gone. Each subdocument may be manually locked up again.

Beside that, I've been able to do "multiple" mail merges in a single document.
To those who, as me, didn't know about subdocuments, try outline view (ctrl + alt + o).


2015-10-15 18:09:28

Kathy Vernacchio

I found this method on TechRepublic

http://www.techrepublic.com/forums/questions/mail-merging-using-two-excel-files/


2015-07-28 13:12:28

Gwen A. Johnson

How do I merge multiple forms using one data source file? Is there a way to have the document start the merge upon opening?

Thank you.


2015-06-24 08:52:43

Milo C.

This is not entirely true. You can do an MS Query and treat the multiple spreadsheets as joined data sources. See Microsoft article KB180599. https://support.microsoft.com/en-us/kb/180599


2015-06-16 16:26:51

Sonja

I am trying to merge a very large excel file into a word document. I am using 2013. All is fine up to a certain point and then Word cuts off my list - the excel doc has a lot more data on that I cannot see in Word...
Please help me!


2014-04-23 03:27:42

lokesh

Well, It is cleared that, my confusion. Till now now I searched for which don't exist, I am very happy for that for your alternative solutions


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.