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

[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

[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?

[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.....

[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!

[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.

[SierraTechORG]

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

[funpro70]

Awesome so far! I am finding one problem. When I merge from Outlook there is a line space between the person's name and the address. What do I do to fix this?

[mclyn82]

The clearest, most understandable tutorial I've yet to see. Thank you for this valuable information.

[SierraTechORG]

@mclyn82 Thank you for your feedback & ranking. I am glad you found the tutorial useful (mailmerge is not all that easy, and I attempted to shed fears in its use). Your post helps me evaluate my approach in conveying the information in an easy to understand format. I appreciate your comments!

[87unmlobo2]

Wow!!--the best explanation of the Word/Outlook mail merge I have seen. Very clear and concise. My Christmas Card Labels are done!

[SierraTechORG]

@87unmlobo2 Thank you for your great feedback and positive rating! The Wizard tool makes it so much easier than some of the other methods in Word, since it prompts you what to do next and we don't have to rely on our memory. Mailmerge is an underutilized feature that makes life so much easier, especially for Christmas Cards! Take care!

[LenPeak]

Thank you very much for this presentation I have tried to do this for the last few years on my Christmas Card List and after following your instructions it worked. Great .Merry Christmas to you

Thanks Again

[SierraTechORG]

@LenPeak Thank you for your feedback Len!, and a Merry Christmas to you!

[kmhjw]

Thanks this was a big help!

[SierraTechORG]

@kmhjw Glad to be of assistance! Thank you!

[kateebg]

Thanks so much. I've been tearing my hair out for 8 hours trying to get mail merge to print labels and finally found this video and... it works!

[SierraTechORG]

@kateebg Thank you for your kind words! As soon as I get some classes prepared, I will do more videos....

[pompa550]

yes my question is how can i print email in inbox beacause i cant find the toolbar either the prin picture and i wonderins if it is elegible to prin a email in outlook? so help me if u can to find toolbar - and the print icon. thank u

[SierraTechORG]

@pompa550 Hi, guess I am confused a little. Are you attempting to Print an EMAIL from within OUTLOOK? If so which Version (2003/2007/2020) so I can determine what you can do to restore toolbar (or Ribbon). You can also Right-Click on email in list and use "Quick Print" in 2010 or Print in Previous versions.

[SierraTechORG]

@pompa550 sorry for the delayed response. You can print email a couple of ways (this changed from 2003). Hold your mouse over the email you wish to print (in left-hand list of emails) right-click and select "Quick Print" The other thing you can do is click the small black "Down Arrow" which you use to customize your "Quick Access Tool Bar" and Select 'Print' then you will have a Printer Icon. Hope this helps and again I apologize for my tardy response.... Take care!

[pompa550]

how can i print ? it hasnt got the picture

[SierraTechORG]

@pompa550 At 12:56 in the video The Print Icon is clicked from within the wizard (right-hand side). The dialog Box appears choose "ALL" as in the video then your printer properties window will open. Are you not seeing it on your screen? Are you watching "Full Scree" HD version? I don't understand what you mean "it hasnt got the picture", I just watched and saw the printing portion (again starts at 12:56 in the time line). Let me know if there is something still confusing.

[JazzyD83]

Very helpful. Thank you very much!

[SierraTechORG]

@JazzyD83 - Thank you for the feedback, glad it was helpful!

[harmonybotanics]

This video was extremely helpful. It answered all of my questions in an easy to understand format. Thank you!

[SierraTechORG]

@harmonybotanics you are most welcome! I have more to come once I replace my microphone.

[vseyeguy]

How can I print Last name first?

[SierraTechORG]

@vseyeguy This can be done from the Wizard.

Select the following Format:

* Mr. Joshua Q. Randall

* Click 'Match Fields' Button

* Find the 'First Name' under 'Required for Address Block' and Select "Last" from list

* Find the 'Last Name' under 'Required for Address Block' and Select "First" from list

Don't check "Remember this matching for the set of data sources on this computer" unless you plan to do it this way all the time.

Click "OK" to adopt the settings.

Complete merge as shown.

[n545ca1]

I struggled for weeks on end with printing labels until I watched your video. Thanks very much for the great tutorial!

[SierraTechORG]

@n545ca1 - Thank you for the kind words. Mailmege can be very aggravating, and there are several tutorials that show how to set up from Outlook through Word by defining your own fields. The common Tasks Wizard was introduced in Office 2002, and is light years ahead of previous versions, helping format your label. I like using the Wizard in this case since it steps you through the templates available in a structured manner. I appreciate your feedback which encourages me to publish more videos.

[GNews10]

Very Helpful!

[SierraTechORG]

@GNews10 Glad I could be of service!