Make the appropriate changes in the new document that appear When you have finished merging the recipient list with the starting document, you will have created your mail merge document which is the final, finished. The Merge to New Document dialog box appears. Under Merge, click EDIT INDIVIDUAL LETTERS.The second Print dialog box appears.From the Default tray pull-down list, make the appropriate selection Click OK To specify the printer, in the Printer section, from the Name pull-down list, make the appropriate selection Make any necessary adjustments Click OK The Print dialog box appears.To specify the feed source,Click OPTIONS. The Merge to Printer dialog box appears.Make the appropriate selection Click OK To print the letters,Under Merge, click PRINT.To remove a recipient from the mail merge, under Make changes, click EXCLUDE THIS RECIPIENT. When finished, click NEXT: PREVIEW YOUR LETTERSĪ preview of your first recipient appears.įor more information on editing the recipient information, refer to Working with the Recipient List. If you have not already done so, write your letter and insert the variable fields NOTE: To edit the recipient information, refer to Working with the Recipient List. Select the recipient(s) you want to include in your mail merge The Mail Merge Recipients dialog box appears. If your Excel workbook has multiple worksheets, select the worksheet containing your list of recipients From the Look in pull-down list, locate and select the Excel workbook you will use for your list.The Select Data Source dialog box appears. Under Use an existing list, click BROWSE.
To retrieve an existing recipient list,.Under Select recipients, select Use an existing list Under Select starting document, select Use the current document Under Select document type, select Letters Navigating to your Excel data document is similar to selecting a Word data document.įrom the Tools menu, select Letters and Mailings » Mail Merge. The field names of your Excel database must begin in the upper-left corner of your worksheet, cell A1 (the first row and column). If you need more information, refer to Mail Merge Wizard: An Overview. NOTE: These instructions assume that you have an understanding of the Word Mail Merge process. This means that you will not have to duplicate information you already have in your Excel database to perform a mail merge. In addition to the features and functions of Excel that make your database useful, you can also use the database to merge information into Word for large mailings. This article is based on legacy software. (Archives) Microsoft Word 2003: Mail Merge: Using an Excel Database for Mail Merge