how to print address labels from excel to avery labels

Browse to your saved label template and open it. Saved Label Templates – select START FROM EXISTING DOCUMENT and click on OPEN.

We’ve written a Template Tuesday guide to creating label templates, which you can view here. Fill in the measurements of your label size and layout, then click OK to create your label template. 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 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.

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. A data source (your list of addresses).View our step by step How To video to learn how to use mail merge to make labels. Watch a video: this advice is also available in video format. This guide will explain how to use Mail Merge to combine a Word label template with a saved list of addresses to create individual address labels. Template Tuesday Presents.how to use Mail Merge to create individual address labels. Or copy the link! How To? – How To Print Address Labels Using Mail Merge In Word

How to print address labels from excel to avery labels