Return to site

How to print address labels from word document

broken image
broken image

Of course the address data is fictional and may not be in the correct format that you need to use.

broken image

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.

broken image