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.
Attaching Specific Files to Mail-Merge E-Mail Messages
Want to add attachments to each e-mail message created in a mail merge? Word doesn't include the capability to do this, but this tip provides a couple of ideas on how you can extend what Word can do when you merge to an e-mail message.
Automatically Determining a Due Date
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.
Beginning a Mail Merge
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.
Can't Merge Alphanumeric Data Correctly
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.
Can't Place Merge Field in Header of a Catalog Merge Document
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.
Changing Label Printing Order
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.
Checkboxes in a Merged Document
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.
Checking Your Data File
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.
Conditional Processing During a Mail Merge
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.
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 being merged. This can present a special challenge, as outlined in this tip.
Controlling Date Formats in a Mail Merge
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.
Controlling Page Numbers in Mail-Merged Documents
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.
Creating Files with Mail Merge
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.
E-mailing from a Mail Merge
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.
Getting Rid of Blank Labels in a Filtered Merge
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.
Getting Rid of Mail Merge Section Breaks
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.
Getting Rid of Spaces in Merged Data
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.
Grouping Records in a Mail Merge
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.
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 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.
Maintaining Fields in a Merged Document
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.
Maintaining Leading Zeroes
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.
Merging and Printing
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.
Merging and Printing a Series of Documents
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.
Merging Formatted Data
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.
Merging Graphics into Word Documents
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.
Merging Only a Date from Access
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.
Merging to Individual Files
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.
Opening Only a Merge Document
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.
Printing Portions of Mail Merged Documents
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.
Proper Comparisons for Dates in Merge Fields
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.
Rounding in a Mail Merge
Word allows you to merge information into a document from various sources such as an Excel worksheet. If you do, you may be surprised at the way that the numeric values appear in the merged document. This tip discusses how you can get those values to appear just the way you want.
Selecting Different Trays in a Mail Merge
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.
Speeding Up Mail Merges
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.
Using Mail Merge to Complete Documents
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.
Using Merge Fields
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.
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 use of Word's mail-merge capabilities. This tip outlines how you can use this capability to get just the serial numbers you need.
Wrong Values Merged from Excel
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.