How to make mailing labels from an Excel list

To make mailing labels from a list in Excel ensure that you have the columns labeled correctly.

Open up a Word document

Select the Mailings tab

Select Mail Merge - Labels

From the next dialogue box select the type and serial number of type of labels that you have

An outline of you labels will appear on your sheet.

Click Select Recipients - use and Existing list.

Select the Excel document that contains the list

Select the sheet where your list is located

Click on Insert Merge field

Select Name and Click Insert

Click close to close the dialogue box and then click enter to get a new row

Click Insert Merge Field again and Select Address

Click close and Click Enter to get another new row.

Click Insert Merge Field and select City

Then click close

Click update Field to copy the same format to all of your labels

Below Finish and Merge, you will drop-down the list-arrow here and select Edit individual Documents.

Now you are able to select the number of labels that you would like to view. I normally select the number of labels on one page

Enter 1 to 30

The labels will be filled with the information from your list. At this point you are able to edit any errors that are detected.

When you are happy with the labels print.

Close the sheet that was just printed.

For the next sheet you will be able to select 31 to 60 and so on.

Instructions for creating labels from a list in Excel

MY videos are all created on Camtasia.
TechSmith Camtasia Click Here