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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |