Creating Mailing Labels Using Microsoft Word and Excel

 

  1. Open Microsoft Excel and create your mailing list.  Put the categories in the first row.  Common categories are FirstName, LastName, Address, City, State and Zip.  You can also use a title category, two address lines, a business name or whatever you need for your label.

 

  1. Open Microsoft Word.  Select Tools, Letters and Mailings and then Mail Merge.

 

  1. Select Labels.

 

  1. At the bottom of the column, under Step 1 of 6, select Next.

 

  1. Select Label Options.    Use whatever size is written on the type of label you are using.

 

  1. Click Select Recipients at the bottom of the page. 

 

  1. Select Browse and go to the Excel list that you want to use. 

 

  1. You will see this screen:

This just means that you are using Sheet 1, or the first page, of your Excel sheet.  Click OK.

 

  1. The labels should appear on your screen with the words Next Record on every label but the first one.  Now select Arrange Your Labels 

 

  1. This is the most important part of the process!  Select Address Block.

 

 

 

 

  1. If you see fields marked "not matched," that means that the label you put in your Excel sheet does not match the label that mail merge gives you.  Select the arrow at the end of each line.  The labels from your spreadsheet will be listed and you select the one you want to use.

 

 

  1. Your label sheet will have the words <Address Block> in the first label spot and <Next Record> in all of the others.

 

 

  1. Select  Update all Labels.

 

  1. Now your label sheet will look like this.

  1. Now select Preview Your Labels. 

 

16.   You will see your beautiful labels.  All you need to do now is put your labels in the printer and print as usual.