Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Create mail merged mailing labels
Dan Holme
October 30, 2007
4 Min Read
There are several ways to approach creating mail merge labels. The approach outlined below is one of the most efficient and foolproof methods.
Ensure that you have a data source created.
Start a new, blank document.
Choose Tools → Letters and Mailings ? Mail Merge.
The Mail Merge task pane will step you through the process of mail merge.
In Step 1 of the Mail Merge task pane, in the Select document type section, select Labels. Click Next.
In Step 2 of the Mail Merge task pane, in the Select starting document section, select Change document layout.
Click Label Options and select the type of label you wish to create.
Click OK to close the Label Options dialog box.
Word changes the layout of the blank document to include a table that is the correct dimensions for the selected label type.
Click Next.
In Step 3 of the Mail Merge task pane, in the Select recipients section, select Use an existing list.
In the Use an existing list section, click Browse.
Locate your data source.
When the Open Data Source dialog appears, be sure to click on the Files of Type drop-down arrow and select All Data Sources or All Files (*.*) or a filter that matches the source of your data.
Depending on the type of data source, you may be prompted to select a specific worksheet, range, table or query.
In the Mail Merge Recipients dialog box, select the records in your data source which should be used in the mail merge, then click OK.
You can filter and sort the list by clicking the drop-down arrows next to the field headings. Choose Advanced from the drop-down list to create a custom filter and sort.
You will be returned to the Mail Merge task pane, on Step 3. Click Next.
In Step 4 of the Mail Merge task pane, you are able to insert the fields in the labels that will be populated by the data source. Position the insertion point in the first label, then select the field from links in the task pane. The Address block, Greeting line and other links create fields using a combination of data in the data source. In each, you can configure the text and fields that are used. The More items link will display the list of fields in your data source. Obviously, the Address block field will be the most common field to utilize in mailing labels.
In the Address Block dialog box, click Match Fields to indicate which fields in your data source correspond to fields in the address block.
After you have configured the first label, click Update all labels.
Click Next.
In Step 5 of the Mail Merge, you can step through a preview of each sheet of merged labels using the Next and Previous arrow buttons. If something looks incorrect, you can click the Previous link at the bottom of the task pane to return to Step 4 of the process. You can also exclude a recipient or modify the recipient list.
When you are satisfied that the merge will produce satisfactory documents, click Next.
In Step 6 of the Mail Merge, you can select Print, which will send the labels directly to the printer. Or you can select Edit individual labels. This option will create a new document that consists of all labels. You can edit individual labels within the merged document, or you can print it.
In the Merge dialog box, you can specify which records to merge. If you select All or a range of records, the merge will be performed only for recipients within that range that are selected in the recipient's list.
You will generally want to save the data source, since you will be likely to need the data source again for mail merges or other tasks in the future. You will generally also want to save the merge document. The merge document is the "original" document with the label structure and the inserted field codes. With these two components, you can re-run the merge at a later date.
You usually do not need to save the resulting document which contains all of the individual labels, because you could always re-generate this document by performing the merge again. Merged labels are usually temporary and dynamic, so it is often not efficient to save a resulting merge labels document.
However, if you are going to edit individual labels, or if your data source or original merge document is going to change, and if you want to preserve a record of this merge, then you would need to save the resulting merged labels document. Alternatively, you can create a backup of the data source and original merge document, so that you could re-run the merge at a later date.
About the Author
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
