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