How to Create Address Mailing Labels in Microsoft Word 2007 Using Excel Data

Wondering how to make mailing address labels? Do a Mail Merge in Microsoft Word 2007!

In this video, Media Baldwin, the Shortcut Queen, answers Christine's question about setting up mail merge labels in Microsoft Word 2007. Merging word documents will speed up the creation of address labels.

Her data source is a Microsoft Excel spreadsheet. The spreadsheet is arranged with the address elements split into multiple columns. Rather than join the address elements in the Microsoft Excel spreadsheet, we will simply use the mail merge labels template to move the fields together.

Once the mail merge is complete you can either save the file as a word document or print your labels in Word immediately.

Visit Media Baldwin at shortcutqueen.com to sign up for free tips, videos and articles!

Also, when you LIKE our Facebook page at www,facebook.com/shortcutqueen , you can download a free booklet of tips and tricks.