How to use Word 2007/2010 Mailmerge Wizard to print Avery Labels using Outlook Contacts

This video tutorial has been created per many requests; demonstrating how to use the Mail Merge function in Word 2010 to Print Address Labels, using contacts from Outlook Address Book. This is the easiest method I have found, because Word formats the label information for you. You can visit: http://www.sierratech.org to view more videos. Word 2007/2010 Mailmerge wizard is similar to version 2002/2003 in the simplification of MailMerge function, by performing many of the steps for you. We train our customers to use Outlook as the default address book, which can be accessed by Office and other applications (although Outlook 2007 changed its MAPI architecture preventing complete integration of applications such as WinFax and is unable to access the WinFax data files from Outlook). WinFax 10.3, however can still use the Outlook 2010 Contacts as its address book, 32-Bit version.

Note: Outlook must be setup as your default email Program for this to work!

Category:

Howto & Style

Tags:

• outlook
• contacts
• word
• microsoft
• office
• mailmerge
• 2007
• 2010
• avery
• labels
• mail
• merge
• wizard
• label
• tutorial
• mailing list
• demo
• database

[sohappy2bme]

Thank you so much. I wish that I had found you 2 days ago! Great video with easy tutorial. Do you have more?

[SierraTechORG]

@sohappy2bme Thank you for the compliment!

Yes, I have some for PICASA and basic email (using Outlook) saving Photo attachments "inline versus attached). I will be updating the old one on my website that shows how to save and use templates for Word 2007 & 2010 (as well as creating a Template Thumbnail in XP different than VISTA or WIN7). The new video will be posted here in January.

[bmaca51]

Hello, thanks for taking the time to do such an informative video. I have a problem when trying to get my address folder pulled up. I get the message " Error has occurred:MAPI folder or address book not found".  I performed the step you recommended to ensure it can find the folder, and it actually comes up on the list, but when I click on it I get the above message. Do you know why?

Thanks,

Brian

[SierraTechORG]

@bmaca51 Hi Brian,

Is Outlook your Default Email Program? To find out, go to the Control Panel, Select "Internet Options", Click on the "Programs" Tab and find the COMBO box for "E-mail". If it is not set to "Microsoft Outlook" then you will receive MAPI errors. Set it to "Microsoft Outlook" if on another program, and click "OK". Let me know what you found!

Thanks for the positive feedback! -Bob

[fionaanderson1963]

Thank you - I had spent all afternoon trying to do my labels until I found your clear explanation!

You have saved me hours of frustration...

[SierraTechORG]

@fionaanderson1963 That's a good thing! We have enough frustration in our lives. Thank you for your comments!

[bmaca51]

@bmaca51

Also, when I cancel out of the window I mention above, it says that it is having problems due to database engine errors.....

[bmaca51]

@SierraTechORG Well, that didn't work. The rest of the feedback that I get once I click "ok" at the error msg is, another window pops up called Data Link Properties, and it asks for a Data Source and Location, along with a place to input a user id and password (Admin is default). I tried screen printing but doesn't work in this reply box...may have to use Excel?

[SierraTechORG]

@funpro70 Glad you found the culprit. So many variables it's easy to make a mistake. Thanks for the feedback!

[funpro70]

Ooops - I found the problem. I had entered an incorrect Avery Label # in. It was for a 1/2" high label - so of course, it didn't look right.