
You'll be prompted to specify the type and / or size of labels you want to generate.
In Word, start the merge and specify the main document for labels. There are 8 steps in the Word mail merge process for mailing or address labels: Recommended article: How to Use Mail Merge in Word for Form Lettersĭo you want to learn more about Word? Check out our virtual classroom or live classroom Word courses > Understanding the label mail merge process in Word Address labels are often called mailing labels or shipping labels. Typically, labels are purchased in sheets that you place in the tray or document feeder of your printer and a product code is printed on the label packaging. When you run the mail merge, you can create a new merged file with a label for each contact or merge directly to a printer. You'll need to create a main document for the labels in Word and then connect to a data set or list in an Excel worksheet (although you can use other data sources). This is typically used to generate and print bulk mailing labels for names and addresses of clients or other contacts. You can create labels in Microsoft Word by running a mail merge and using data in Excel. This will create a new document of labels so that they can be reviewed and printed.Create and Print Labels in Microsoft Word Using Mail Merge and an Excel List (Generate Bulk Address or Mailing Labels)īy Avantix Learning Team | Updated January 9, 2021Īpplies to: Microsoft ® Word ® 2013, 2016, 2019 and 365 (Windows) Click Finish and Merge and select Edit Individual Documents. Use the Preview Results field to check the setup of the labels and make corrections as necessary. Click Update Labels to copy the merge field to all labels. Click Insert Merge Field to set up your first label. Select the sheet that contains the data (if you have not modified the export from Vantaca, it will be Sheet 1. If Excel needs to convert the file, allow it. Select the details for the manufacturer of your label paper. In the ribbon at the top, click Mailings. Open Microsoft Word and create a new document.
Click Export to Excel and save the file to your computer.
Either search to filter for the owners that you want.For Mailing Labels, we recommend "Homeowner Name", "Mailing Address 1" and "Mailing City, State, Zip". Use the column settings to display the available columns that you would like.Navigate to Homeowner > Homeowner List.Question: How can I create a Mail Merge for Homeowner Mailing Labels in Microsoft Word?