For more information, see Prepare your Excel data source for mail merge in Word. Changes or additions to your spreadsheet are completed before it's connected to your mail merge document in Word. Mail merge is also used to create envelopes or labels in bulk. You will now see an address on each label. Using Mail Merge, you can easily customize form letters for individual recipients. (This works with Google Docs’ spreadsheets. Open Microsoft Excel or whichever spreadsheet software you use. Merge Data from an Excel Workbook into a Word Document. For more info, see Data sources you can use for a mail merge.
Step 2: Set up your mailing list The mailing list is your data source.
In the Write and Insert Fields group, click Update Labels. Go to Mailings Start Mail Merge E-mail Messages. In the Preview Results group, click Preview Results you will only see one address per sheet of labels. In the Write and Insert Fields group, click Address Block and ensure the fields match what are required.
If needed, click Edit Recipient List to choose specific people to create labels for. If required, locate where your list is o you computer. In the Start Mail Merge group, from the Select Recipients dropdown, select one of Type New List, Use Existing List or Select from Outlook Contacts. Select the name of the company whose labels you are using from the Label vendors dropdown, then select the relevant Product number. If necessary, change the Printer information detail. The Label Options dialog box will be displayed. To create mailing labels, from the Mailings tab, in the Start Mail Merge group, from the Start Mail Merge dropdown, click Labels. Only one label is being printed on each sheet of labels. Here, you can select your label brand and product number. In the drop-down menu that appears, select Labels. Do not include blank rows or columns in the address list, because the list of labels that is created might not be complete beyond the blank rows and columns when you set up the labels for the mail merge in Word. In our example, we are using Avery labels. In the Label vendors drop-down list, select the type of labels you are using.
If you plan on printing one page of labels at a time, keep the tray on Manual Feed otherwise, select Default. In the Label Options window, select the type of paper you want to use. One or two clients have mentioned problems with creating mailing labels, using Word 2007 or Word 2010 mailings tab. Next, head over to the Mailings tab and select Start Mail Merge. In Microsoft Word, on the Office Ribbon, click Mailings, Start Mail Merge, and then labels.