In this tutorial, you will learn how to print address labels from Excel.
A Microsoft Word mail merge can be used to send a bulk mailing to an address list that you have in an Excel spreadsheet. Each mailing label on the sheet that results from the mail merge procedure has one address from the list, and you can print the sheet.
Once ready, we’ll get started by utilizing real-world examples to show you how to print address labels from Excel.
Table of Contents
print address labels from Excel
You can easily print address labels from Excel.
First, you need an existing data group to form the labels in Microsoft Word.
Then, open a Word document. Then select ‘Mailings’ and select ‘Labels’.
A pop-up box will then appear, make sure to select the options as shown below to create the labels.
Then we will insert the existing address list from Excel to the Word document to create the labels. To do so, select ‘Mailings’ then select ‘Use an Existing List’. You then select your saved Excel file.
Now your labels will appear like this.
Now we will include the merge fields into the Word document.
We then select ‘Update Labels’ to update all the labels to include all of the address. Then we select ‘Preview Results’ to see the final label.
Once you are done, your labels will look like this.
That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.
In this tutorial, I covered how to print address labels from Excel.