A4/A5) and click OK.Ĭreate A Label Template – follow the steps above but instead of choosing a code, click on NEW LABEL. Set “Printer Information” to “Page Printers” and choose your “Label Vendor” (e.g. As mentioned above, you can use a compatible template, a Word template you have previously downloaded and saved, or create a new label template.Ĭompatible Template – select CHANGE DOCUMENT LAYOUT and click on LABEL OPTIONS. This is where you select your label template. MAIL MERGE: STEP 2 – SELECT STARTING DOCUMENT To create a set of address labels, you will need to select LABELS from the list of documents. MAIL MERGE: STEP 1 – SELECT DOCUMENT TYPE
![how to print address labels in word merging excel fields how to print address labels in word merging excel fields](https://www.lifewire.com/thmb/kyH8G9LZQhYSLtViZ8D8XuutLCQ=/1089x683/filters:no_upscale():max_bytes(150000):strip_icc()/startmailmerge_labels-a161a6bc6fba4e6aae38e3679a60ec0d.jpg)
You will primarily use this panel to set up your address labels. This panel will guide you through the SIX STEPS of the mail merge. This opens the Mail Merge Wizard panel on the right hand side of your screen. Click on START MAIL MERGE and select STEP BY STEP MAIL MERGE WIZARD. Click on the MAILINGS tab at the top of the page.
#How to print address labels in word merging excel fields how to#
We recommend using Word’s STEP BY STEP MAIL MERGE WIZARD and this guide will show you how to use the Wizard to create your set of address labels. Word label templates and measurements for all of our label sizes can be found in our Label Templates section. If your label size doesn’t have a compatible code, you will need a saved copy of a suitable Word label template OR the measurements of your A4 labels. Ideally, you should use a compatible template that is built into Word. You can use an Excel Spreadsheet, Outlook Contact List, Office Address List, Word Data File, Access Database, or Text File.