Next, we will click Details and format labels as desired.įigure 11- Format size of labels to create labels in excel.Enter product number listed on the package of label sheetsįigure 10 – Adjust size of labels for converting excel to word labels.Choose supplier of label sheets under label information.In the label options dialog, we will select the needed options including.We will select Change document layout because we want to create a new sheet of mailing labels (we can also click start from existing documents or use the current document if we wish to add to an existing list of labels).įigure 9 – Excel to labels for Mail Merge.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.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 Select from the Paper menu, and then select the required envelope size, and then click two times.We can create or print a mailing list by using Microsoft Excel to keep it organized.The Add Exceptions window will be displayed. Select from the Output Paper Size menu, and then click.Click on the tab, and then select from the Paper menu.Select the printer and then click on the button.The envelope will be displayed at the top of the document. Click on the button and select the envelope size from the Envelope Size menu.Enter the delivery and return addresses in the appropriate areas.The Envelopes and Labels window will be displayed. Click on on the toolbar, select, and then select.Open the document to be printed in the application.The PCL version does not have Special Pages tab. NOTE: This solution assumes you are using the Post Script print driver. The Microsoft Word 2003 Envelope and Label wizard can be used to configure the printer to print a single letter (or multiple copies) with an envelope as the first page of the job and the remaining pages printed on standard Letter sized paper (or other selected size). DocuShare Enterprise Content Management.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |