Mail Merge (Microsoft Word)
Word has a Mail Merge manager that makes putting individualized data into your document easy. The following articles explain the steps to perform a mail merge in Word to create labels, forms, notices, etc.
printed with pieces of data from an input file. Taking advantage of this powerful tool in Word can save hours when preparing to print documents.
Tips, Tricks, and Answers
The following articles are available for the ‘Mail Merge’ topic. Click the article”s title (shown in bold) to see the associated article.
When you are doing a mail merge in Word, you may need to calculate a date sometime in the future. Word doesn’t include an option to do this, but there are a couple of workarounds you can try.
Performing a mail merge can be intimidating to some people. It needn’t be; Word provides a handy step-by-step wizard that will lead you through the process.
When you merge data from Excel into a Word document, you may need to do some conditional processing based on the data you are merging. This can lead to some screwy results at times. Here’s an example and how to fix it.
Word can perform several different types of mail merge operations, and the type you choose can affect how you are able to use merge fields in the merge document. This tip explains how catalog merges are different from other types of merges, and how that affects placing merge fields in a header or footer.
If you want to change the order in which labels are printed when doing a mail merge, Word doesn’t provide many options. This tip examines some ideas on how you can change the printing order to match your needs.
When creating a mail-merge document, you may want to include some special characters, such as check-marked boxes, in the document. This is relatively easy to do by putting together the proper type of merge field, as discussed in this tip.
When you get ready to merge a document with a data source, you’ll want to make sure that everything is “as expected” before proceeding. Here’s how to check out the information in your data file.
The Mail Merge capabilities built into Word can appear limited at first glance. One thing that is often overlooked (and which makes the capabilities more powerful) is the ability to add conditional processing to your merges. Here’s how to conditionally control how Word handles merging.
When merging data into a Word document, you may want to add information to the document based on an evaluation of what is being merged. This can present a special challenge, as outlined in this tip.
One of the data sources that Word allows you to use for your mail merges is an Excel worksheet. You may get unexpected results, however, if you believe that the formatting used in Excel should merge smoothly into your Word document. This tip looks at how you can control the formatting for dates.
Getting page numbers just the way you want when merging documents can seem a bit tricky. Here’s how to make sure they reflect your needs.
When you use mail merge to create a document that incorporates all your data source records, you end up with a large document that is divided into sections. You can use a macro to easily split such a document into individual files, one for each data record.
Word has a great mail merge capability. Inherent in this capability is the option to send your merged documents via e-mail. Here’s a quick overview of how to perform this task.
When you use the mail-merge capabilities of Word, the information merged takes on the formatting of your source document, not your data source.
If you want to apply different formatting to some of the information you merge, you’ll need to use the technique illustrated in this tip.
If you are filtering a mail merge in Excel, and you get blank labels in the printout in Word, chances are good that something is going wrong.
(Filtering should suppress those blank labels.) This tip provides some guidance on what you should look for in your merge document to get the desired results.
When you create a group of documents from a merge file, Word normally inserts section breaks between iterations of the document. If you need to get rid of those section breaks, there are a couple of approaches you can take.
When you merge information with a Word document, you may not be completely satisfied with the appearance of some of the merged information. For instance, a merge field may include spaces within the information that you would rather remove. Here’s a couple of ways you can get rid of those spaces.
Need to group records in some manner when they are used in a mail merge?
It can be frustrating when your records are not ordered in the way you want, but this seems to be a general limitation of Word. The solution is to look to how you are organizing the data in the source program.
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 the document.
Word remembers the relationship between the two files when you later open the document. If you send the two files to someone, it is possible for the relationship to be lost. This tip explains why this can happen.
When merging documents, you may want to include some fields in the merged documents. For some fields this is impossible, as to include them would make no sense.
When merging ZIP Codes from a data source such as Excel, you might find that Word ends up dropping out leading zeroes in the ZIP Codes. Here’s how you can make sure that those digits are not dropped.
When you merge information into a document, Word provides two different ways you can create your output. Here’s an overview of those output options and how you can choose them.
Do you need to merge and print a number of documents in a particular order? Perhaps the best approach is to record a simple macro to repeat the merging and printing, as needed.
Using the mail merge feature of Word, you can make data from Access databases accessible for your documents. How information is stored in the Access database can affect the way that data looks once merged into Word. This tip discusses ways you can make phone numbers appear formatted properly in Word.
Ever want to expand the mail merge feature to include graphics? Merging graphics into your document is easy but requires some know-how. This tip explains how Word handles the process.
When you are merging data from an Access database, you may get more information than you want, especially when it comes to times and dates.
There are two potential solutions to this problem, both of which are detailed in this tip.
The mail-merge feature in Word is a fast, easy way to create form letters addressed to many different people. Sometimes, however, you might need to save the resulting documents into separate files for each address. Here’s how.
After merging the information from a data source into a document, you may decide that you only want to open the merge document from that point on. This tip explains how Word treats the files involved in a mail merge.
When you use a data source to create a bunch of documents in a mail merge, you might not want to print all the documents created by Word.
Here are a number of ways you can print just what you want to print from the merge.
How Word merges a data source with a document is controlled by merge fields. In those fields you may want to compare dates to determine what Word displays. Here’s a primer on how these comparisons occur.
When you create a mail-merged document, you might want some pages of the document printed on paper from one printer tray and other pages printed from paper in a different tray. This can be easily accomplished when you create your merge document to begin with.
The Mail Merge tool in Word is a great way to create new, customized documents. If you are doing a lot of merging, you may notice that your merges slow down after a time. This tip discusses some of the possible reasons.
Mail merge can be used to put together groups of documents that rely on common information. This tip shows how mail merge could be used to make your document generation easier.
When creating a mail merge document, you use merge fields to indicate where the information from each record of your data source should be inserted. This is easy to do, as Word provides two ways you can access the fields.
If you need to include serial numbers in your printed matter (labels, letters, documents, etc.), the best way is through the use of Word’s mail-merge capabilities. This tip outlines how you can use this capability to get just the serial numbers you need.
When you use an Excel workbook as a data source for your merged document, you may be surprised if what is merged doesn’t match what you see in Excel. This could be due to how Excel formats and displays numbers and how those numbers are shared with other programs, like Word.