Written by Allen Wyatt (last updated March 9, 2019)
This tip applies to Word 97, 2000, 2002, and 2003
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.
Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!
When you use an Excel workbook as a data source for your merged document, you may be surprised if what is merged doesn't ...
Discover MoreWhen you use mail merge to create a document that incorporates all your data source records, you end up with a large ...
Discover MoreWhen merging ZIP Codes from a data source such as Excel, you might find that Word ends up dropping out leading zeroes in ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments