Please press Update Labels button shown in below screenshot. Placeholders in label template is shown only for a single label at this point. Unit field, then press enter to continue with a new lineĪddress and State fields with a space character between them. Press Enter after > and in new line, add following fields in order using the same button Insert Merge Field So it will not confuse readers with the Title information. It is more readable visually if you select Fullname and place a space character in front of it. You see > and > fields are placed on the Word template for printing labels. Let's now add Excel data columns on to the Word label template.Ĭlick on the top-left label placeholder area which is empty.Įither from the drop down list of field names existing on choosen Excel file or from the dialog screen which contains the list of Excel columns, choose Title and Fullname in order. If you have a similar case, press Edit Recipient List button.įor my case, I selected rows with value "Yes" in "Recipient" column as seen in below screenshot.
If Recipient cell has Yes as value then it will be printed in the label and if it has No then I want to skip this line in the Excel while printing labels with Word document. Maybe you will remember, I don't want to print labels for all rows in the Excel sheet.Īnd as a filter, I want to use the Recipient column value for each row in the Excel document. There is only > which enables the Word document processor to read the next data row from the Excel file. Since we have not yet started to customize labels and place Excel data within labels, the Word template is empty. This Word document is actually a template and is only a single page document. Now the view of the Word document is changed slightly and is in the following form. Then select the sheet that has the recipient names and address data This selection will open a file dialog where you need to point to the Excel document with recipient names and address information for printing labels. If you want to read the recipient names and address data from Outlook, then you have to choose the third option Choose from Outlook Contacts. The existing list is actually our address data from Excel document. Or as an other option, you can create a new label and customize it according to the sizes of the labels you haveĪt this step, although you will see an empty Word document at first look, if you look carefully using Ctrl+A or partially select sections of the document, you will see 14 placeholders in two columns as seen in following screenshot.Ĭlick on Select Recipients button and choose Use an Existing List. If you don't know the vendor, you can choose a label which matches to your label sizes. If so, please choose the provider among Label vendors and the corresponding provider label from Product number.įor example, I have TANEX 2014 so I made following selections on the Label Options screen.
If you have the labels that you are going to print recipients and address data, probably you already know the label provider and label code. On Mailings tab, first press on Start Mail Merge ribbon button and choose Labels.
Word document provides shortcuts to tools in Mailings tab to create templates for printing label, envelopes, etc and choose recipients from Outlook Contacts or from Excel data.
You can download this sample address data Excel file using the referenced link for your tests to print labels using Word document and Excel file as the data source of the label information.Īnd also you can download the final version of the Word template label-template.docx too.įirst of all, let's create an empty Word document and name it as "label-template.docx" We will see the label fields as a customization of the layout soon in this guide. If you have more columns to use in the address like country, etc or even if you want to print the phone number information on the label it is very easy to customize the template that will be used for label printing. Of course the address data is fictional and may not be in the correct format that you need to use.
Other Excel data contains a title like "Dr.", etc and the full name of the recipient.Īdditionally the company name if exists that the recipient is working at is stored in the Excel data sheet.Īnd for the address, we have Address and State columns. In short we will not print address rows with "No" in "Recipient" column. First of all, I want to share below Excel document which includes imaginary people and imaginary address data to print using the label template we will create in following steps in this tutorial.Īs seen above, the Excel data has a column named "recipient" that helps us to decide or filter which data rows to print on labels as a recipient.