How to Print Mailing Labels from Excel?

Open your Excel file and make sure each column has a header, such as Name, Address, City, State, and ZIP

Check that each row contains one complete mailing address

Save the Excel file

Open Microsoft Word

Go to the Mailings tab

Select Start Mail Merge

Choose Labels

Select the label vendor and product number that matches your label sheets

Click OK

Select Use an Existing List

Browse to and select your Excel file

Choose the correct worksheet and confirm the first row contains headers

Insert the merge fields into the first label

Format the first label as needed

Click Update Labels

Preview the labels

Click Finish and Merge

Choose Print Documents

Select your printer and print settings

Print the labels on your label sheets

Suggested for You

Trending Today