office 2016 mail merge label prints one label per page

#OFFICE 2016 MAIL MERGE LABEL PRINTS ONE LABEL PER PAGE HOW TO#

We will select Labels and click on Next: Starting document link.We will now see the Mail Merge pane at the right of our screen.įigure 8 – Mail Merge pane for making mailing labels.We will go to the Mailings tab, select Start Mail Merge and click on Step by Step Mail Merge Wizard.

We will open a blank Word document in Ms Word 2007, 2010, 2013 or 2016įigure 6 – Blank word document to convert excel to word labels.Step 2 – Set up the Mail Merge document in Word Once we are done, we will save our Excel worksheet.We will type in a name for our address list in the Name box.įigure 5 – Name address list for labelling in excel.In the Defined names group, we click on Define name.įigure 4 – Define Name for mailing labels from excel We will select the address list including column headers and go to Formulas.Next, we will fill in our data ( Format the Zip Code column to enter numbers as text)įigure 3 – Create labels from excel spreadsheet.Tip: Rather than create a single name column, split into small pieces for title, first name, middle name, last name. First, we will enter the headings for our list in the manner as seen below.

#OFFICE 2016 MAIL MERGE LABEL PRINTS ONE LABEL PER PAGE HOW TO#

In this tutorial, we will learn how to use a mail merge in making labels from Excel data, set up a Word document, create custom labels and print labels easily.įigure 1 – How to Create Mailing Labels in Excel Step 1 – Prepare Address list for making labels in Excel We can create or print a mailing list by using Microsoft Excel to keep it organized.

Office 2016 mail merge label prints one label per page