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