importing excel data into word for labels

IMPORTING EXCEL DATA INTO WORD FOR LABELS HOW TO

As you can see, the first line of the sample address has the individual s name duplicated. The Insert Address Block dialog box shows a sample address, based on the default address elements specified and my Excel data file, below. Since I m making a simple label, I don t need the Greeting Line or Electronic Postage items, so I just click on Address block 13. The Mail Merge panel will help me to transfer the material in my Excel data file into a format proper for placement on my page of labels (note the placekeepers on the form at right). I click on the indicated link to move to the next step.Ĥ 12. The bottom of the Mail Merge panel informs me of the next step in the process, which is to Arrange your labels. I m going to select the entire list by checking this box, and then clicking on OK. The Mail Merge Wizard imports my Excel file into a Mail Merge Recipients dialog box, which allows me to select all or just some of the file entries, and to sort or filter them in a variety of ways. The panel then supplies me with a Browse link to find the file I have in mind. I m going to use an existing Excel file, so I click on the first choice. The top of the panel again gives me a choice of where to draw the label address information from. The bottom of the Mail Merge panel now indicates the next step in the process, so I click on the Next: Select recipients link.ģ 8. I highlight the one I want by clicking on it, then select it by clicking on the OK button. Then I sort through the product numbers which display once I ve picked the vendor. First I pick out the label vendor to whose products I have access in this case the pioneering supplier Avery. The top of the panel now asks whether I want to use the existing document or change its layout, to create a page of labels I click on the latter choice, then click the Label options link to access a list of label sizes. I click the Next: Starting document link to begin the process. The bottom of the Mail Merge panel now displays the first step in the wizard process.

From this point on, I ll be shifting back and forth between the top and bottom of this panel.Ģ 4. I ll select my document type by clicking in the circle by the word Labels. A Mail Merge panel opens to the right of the Word document. I ll then select the Step by Step Mail Merge Wizard option at the bottom of the resulting drop down menu. Employment & Career Development Division Training Academy 2. I open up a new Word Document, then: Go to the Ribbon and select the Mailings tab on the Ribbon, and I click on Start Mail Merge, in the section by that same name, to display the mail merge options. Prior to starting this process, you must have a saved Excel document with name and address information in tabular form review your document in determine which spreadsheet contains your information. To print mailing labels, you ll import Excel spreadsheet data into a Word document using the Mail Merge function.

IMPORTING EXCEL DATA INTO WORD FOR LABELS HOW TO

1 Create Mailing Labels Using Excel Data (Mail Merge) This quick guide will show you how to create mailing labels from an Excel spreadsheet.

Importing excel data into word for labels