Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Using Mail Merge to Complete Documents.
Written by Allen Wyatt (last updated October 11, 2023)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365
Word's mail-merge feature is most often used to create what used to be called "form letters" or to create labels from a list of individual pieces of data. Another use for mail merge, however, is to use it to help create complete documents from a group of individual pieces. You can use mail merge to easily complete standard documents that have well-defined items that must be changed each time the document is composed.
Over time you might develop source documents to use with your business. For instance, if your business involves estate planning, you might develop documents dealing with powers of appointment, health care directives, trust agreements, wills, real estate deeds, etc. Each document could have many of the same elements: names of parties (such as document creators, beneficiaries, and trustees), dates, addresses (counties, cities, streets, states, ZIP Codes), genders, etc. Since those elements are common, it seems logical to place merge fields in those spots in the documents where the common elements are required.
You can then create a data input file that consists of a Word table with the specifics for each client. This information can be easily put on a CD and kept in a client's folder. A macro, initiated by simple, easily remembered key combinations, could then be used to create the final merged document.
The benefit is that an approach like this allows you to create whole sets of documents in short order. By using mail merge in this manner, you can produce exactly what you need very quickly. For instance, if you were (again) in the estate planning business, you might be able to create a rather lengthy death tax efficient trust agreement, one or more wills, powers of appointment, sets of health care directives, lists of instructions and sample letters, and other related documents in less than half an hour.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (10970) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365. You can find a version of this tip for the older menu interface of Word here: Using Mail Merge to Complete Documents.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
If you are filtering a mail merge in Excel, and you get blank labels in the printout in Word, chances are good that ...
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 MoreWhen merging data into a Word document, you may want to add information to the document based on an evaluation of what is ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-03-30 11:05:57
Bob Jann
How can I design a macro that prompts me for the data to put in fields item by item rather than by me having to create a separate data input table first -- and, without having to learn how to use VBA (something I have tried but don't have the time to master)? I want to be able to open a boilerplate document, start a macro and semi-automatically replace the form fields with appropriate text (for example name, date, pronoun). Or, is there another way to do this besides a macro?
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu 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 © 2024 Sharon Parq Associates, Inc.
Comments