how to print address labels from excel data

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.

How to print address labels from excel data