I am getting used to the new Microsoft Office 2007 however it takes time to find out where everything is. I am not a fan of mailers but if you are going to do them I am all about convenience. Now I know most of us have assistants that do this for you but here is a simple step by step to complete you mail merge for those “do-it-yourselfers“. Hopefully you all have a database of some sort.

Things you will need to know first

Where your excel data base file is located on your computer

What type of labels you are going to be printing

To Print Labels

Open a Microsoft Word Document

Click on Mailings

Select Start Mail Merge

Select ‘Step by Step Mail Merge’

Click on the labels radio button to the right (it’s near the top of the screen)

Click on ‘Next: Starting Document’ (bottom right of the screen)

Click on Label Options (toward the top on the right of the screen)

Pick Avery Standard

Pick Product Number 5160

Click OK

Click ‘Next:Select Recipients’ (bottom right corner of screen)

Click on Browse (back toward the top on the right side of the screen)

Select the location of your excel database file and teh name of the file

Click Open

Select the Sheet you want to use to print your labels

Click OK

Click the Select ALL button

Click OK

Click ‘Next: Arrange your labels (bottom right corner of the screen)

Click more items(toward the top on the right side of the screen)

Select First Name

Click Insert

Click Close

Press the space bar to insert a space after the first name

Click more items (toward the top on the right side of the screen)

Select Last Name

Click Insert

Click Close

Hit the enter key once to drop down to the next row on your labels

Click more items (toward the top on the right side of the screen)

Select Address

Click Insert

Click Close

Hit the enter key once to drop down to the final row on your labels

Click more items (you know where it is )

Select City

Click Insert

Click Close

Hit the comma key and the space bar to add a comma and the space after the city

Cllick more items (it’s still in the same place 🙂 )

Select State

Click Insert

Click Close

Click more items (last time I promise)

Select Zip code

Click Insert

Click Close

Your first label should be ready now. But wait there is more!

48. Click on Update all Labels button (middle right side of screen)

49. Clikc on Preview your labels (bottom right corner again)

If your labels look good

50. Click on Complete the merge (bottom right corner)

51. Make sure your printer has the proper label paper in the proper tray