Or, it can combine several entries, for example the «AddressBlock» field.

A merge field can correspond to one entry such as first name, last name, city, zip code, etc. In essence, when you mail merge labels or envelopes from Excel to Word, the column headers of your Excel sheet are transformed into mail merge fields in a Word document. The steps are essentially the same in Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2010, and very similar in Excel 2007. Whatever intricate and intimidating the task may sound, it boils down to 7 basic steps.īelow, we'll take a closer look at each step using Microsoft 365 for Excel. If you've had a chance to read our Mail Merge tutorial, a larger part of the process will be familiar to you because making labels or envelopes from Excel is yet another variation of the Word Mail Merge feature. Just remember to Pint off to scale.How to mail merge address labels from Excel That way if something is wrong you can troubleshoot without wasting any label sheets. Print off a few copies of the template on regular paper before printing on the label sheets. Just hide the template layer before printing so that the label lines do not print.Īvery® Compatible Sizes: Click here to see our compatibility chart. Create a second layer and input your artwork.

Open the file in your program and lock that as a layer. Right-click and save the PDF file to your computer for use in Illustrator® or any other designing software as a template to layout out your art. If you don't see the label outline, please turn on your Label Gridlines and they will show up. Right-click on the MicroSoft Word® document and save the template to your computer for opening in Word. You may need to use these if you are using a program that you have to enter the label dimensions yourself.

Use the detailed image to view the exact layout of the labels on the sheet, as they have the length and width, top and bottom margins, and spaces between the labels marked. All label templates are free to download. Below is a list of all our label sizes with a detailed drawing (JPG), a downloadable MicroSoft Word® template (DOC), an Adobe Acrobat® scaled (PDF) label template, and template files for use in Adobe PhotoShop® (EPS). If you need help setting up your label template, you are in the right place.

Microsoft word address labels template