Mail merge address labels how to#
Mail merge address labels update#

The Print dialog box appears.Make any necessary adjustment. To print labels for only certain records, enter a range in the text boxes Click OK To print a label for only the record displayed, select Current record The Merge to Printer dialog box appears.To print labels for all of your records, select All To print the labels,Click FINISH & MERGE » select Print Documents.OPTIONAL: To preview your document with other recipients' information, in the Preview Results section, click the arrows NOTE: For more information on editing the recipient information, refer to Working with the Recipients List.

Mail merge address labels update#

To use the same fields and layout for for each record, in the Write & Insert Fields group, click UPDATE LABELS In the Write & Insert Fields group, click INSERT MERGE FIELD » select the desired field

Position the insertion point in the top left label.

NOTE: To edit the recipient information, refer to Working with the Recipients List NOTE: A recipient is selected if the checkbox beside their entry is selected.

In the Start Mail Merge group, click EDIT RECIPIENT LIST.

To select the recipient(s) you want to include in your mail merge,.

The Select Data Source dialog box appears.įrom the Look in pull-down list, locate and select the file you will use for your list In the Start Mail Merge group, click SELECT RECIPIENTS » select Use Existing List. To specify the paper source for printing, from the Tray pull-down list, make the appropriate selection NOTE: The most common brand is Avery standard.įrom the Product number scroll box, select the product number of your labels įrom the Label products pull-down list, select the brand name of your labels In the Start Mail Merge group, click START MAIL MERGE » select Labels. You can choose the label size, text font, positioning of the information, etc., to suit the needs of your particular project. When creating labels, you have many options.

Mail merge address labels how to#

The following instructions describe how to merge a pre-existing database's values into address labels with the Mail Merge Wizard.īegin the process of creating mail merge labels by setting up your starting document.

Using data from a table or external database, you can print one label with different information for each record in the database or table. Mail Merge allows you to set up mailing labels that use the same format with information from a variety of records. This article is based on legacy software. Once every field is added, click on Close.(Archives) Microsoft Word 2007: Mail Merge: Creating Merged Mailing Labels For example, here we will need to click on First Name and then click Insert, then click on Last Name and then Insert, and so on. Click on each field and then click on Insert one at a time. This is where you will choose which of your columns are merged and in what order. Then at the bottom click on Next:Arrange your labels.Ĭlick on More Items and it should open a new window for Insert Merge Field. Scroll through the options to make sure the data is correct and click on OK. Now you should be able to view your Mail Merge Recipients. Once you find and open your database file a window will appear asking to select a table. Then click on Next:Select Recipients.Ĭhoose the option to use an existing list and click on Browse. Then click on your product number and click on OK.

Printer Information is set to Page Printers.

In the Label Options window, make sure that: Click Start Mail Merge, then Step by Step Mail Merge Wizard.Ĭlick on Labels and then click on Next:Starting document. In Microsoft® Word click on the Mailings tab at the top of the screen.