how to print labels from excel 2008 for mac

In real life, it is a tricky job to try printing labels on the paper sizing beyond standard documentation.

Believe me, a lot of people are there in the world, who are struggling with this issue.

However, a proper step by step guide along with some practice will do the task for you guys.

Excel can be way too handy in this regard due to its spreadsheet format which is ideal for storing contact and address information of the user.

Using mail merge feature with Microsoft Word you can do this task neatly and print out the mailing labels with ease directly from Excel.

As we want to create mailing labels, make sure each column is dedicated to each label.

Ex. Salutation, First Name, Last Name, Address, City, State, Postal Code these should be the columns and respective information should be filled in those columns.

It is mandatory to set some file format settings under Microsoft Word so that you can use the excel file into it.

Basically, this step helps to have a smooth conversion between Word and Excel.

Click Advanced. Under Advanced settings, scroll down to the General settings section.

Under that, select Label vendors as Avery US Letter, Product number as 5160 Address Labels.

Select the file in which the labels are stored and click Open.

Click on OK to let the system know that you want to use the data source.

Click on OK to select the table from your excel sheet for labels.

If you feel you have some labels not assigned proper columns, you can change the same.

This will allow the first name from our list along with address details to get assigned to that first record.

After this step, you will be able to see the mailing labels on a new word sheet and can print them.

Select All in Merge Records selection and click OK to merge all the information from the excel sheet to the word mailing labels.

Here we discuss the Steps to Print Labels from Excel along with examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

How To Print Labels From Excel 2008 For Mac