Search OutlookPower's 8,981 Outlook and all-things-email article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
THIS WEEK'S POWERTIP
Mail-merging labels and a trick for searching OutlookPower
By Diane Poremsky

A reader, Jerry Morrison, writes:

I am an avid fan of your Outlook newsletter.... great... I guess the only question I have is how does someone like me get an answer on an Outlook question that may have been covered your articles... but I may have missed?

The question I have is it would be really keen if there was a link between Outlook and MS Word's mailing label printing functions... how nice it would be to send my "Christmas" category to the label printing program... I am sure someone has already figured out a way (an easy way)... and would love to find the answer... it would save me lots of hours at Thanksgiving, Christmas, and other occasions...

Thanks for listening... hopefully you will give me guidance on both items above...

Thank you for writing and I'm glad you like the newsletter. Back issues of Outlook Power are on the website at http://www.outlookpower.com/backissues/backissues.html. While we don't have a search utility (we're working on it), finding the back issue you need isn't too difficult.

[You can also go to Google, type in your search request, and end it with "site:www.outlookpower.com" (without the quotes). The search will then be limited to OutlookPower's Web site. By the way, this trick works with all Web sites. Any time you prefix a domain with site:, Google will limit its search results to that site. We use it all the time! -- DG]

Mail-merging labels
As you look over the list of back issues you'll notice one of the July columns mentions mail merge--that's the column you need to answer your second question. Although that column is about using mail merge to create form letters, you can just as easily merge to mailing labels. You can find "Use Mail Merge to customize form letters" at http://www.outlookpower.com/issues/issue200307/00001065001.html.

Since mail merge is a very popular topic, I'll briefly go over the basic steps you'll need to create your labels. Begin by applying the By Category view to your contacts, then select the contacts in the Christmas category. You'll need to select the first one, then hold shift and scroll down to select the last one, selecting the category heading won't cut it with mail merge.

Once the contacts are selected, use the Tools, Mail Merge menu to open the Mail Merge dialog. Choose Mailing Labels as the document type and click Ok to begin the mail merge process. Outlook creates a document containing the contacts which is the data source Word uses for the merge. Once it's created, Word opens and you can use View, Task pane to show Word's mail merge task pane if you need help completing the merge.

There ya go! And don't forget to send out those Halloween cards first!

Diane Poremsky is the president of CDOLive LLC and a Microsoft Outlook MVP. She's author of Teach Yourself Outlook 2003 in 24 Hours (Sam's, 2003) and coauthor of OneNote 2003 for Windows (Visual QuickStart Guide). For questions or suggestions for future columns, write her at outlook@cdolive.com.


Other articles you might like
Home > Using Outlook > Contacts & Address Book (27 articles)
   Printing notes with contacts in Outlook 2007
   A very crude way to print Outlook contact pictures
   How to separate email accounts and still manage them
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent OutlookPower Articles
Running auto-respond rules when Outlook is closed
Running rules when Outlook is closed
Disappearing text that's not supposed to disappear
What to do when Outlook complains about a program you know you uninstalled
Nothing says new year better than emails from crazy people
Say goodbye to the Uh-Ohs. Long live the Tens.
How to have a clean inbox in 2010
OutlookPower News Center
EML to PST Converter - Conversion of Email Formats to Outlook
Windows 2000, XP SP2, Vista RTM support nears end
Windows 7 Just Being Honest About Battery Life
Remo Software Launches Data Recovery Software
US scientists get free cloud on-ramp
Leaky anti-virus defences letting malware through
Patch Tuesday Release Will Tie Microsoft's Record
>> Read all the news
More from the ZATZ journals
Computing Unplugged: The iPad: Apple's latest heartbreaker
David Gewirtz Online: CNN commentary and analysis
DominoPower: Lotusphere 2010: mobility and collaboration
-- Advertisement --

Write for OutlookPower today!
Share your experience and expertise with other Outlook and Exchange users, administrators, and developers. OutlookPower Magazine has grown nicely and now has new opportunities for contributing authors and editors.

Write about something you're an expert on and get your name in lights.

For Writers' Guidelines and to discuss topics, contact Staff Editor Steve Niles. This is your opportunity to shine in front of your peers, your clients, and other readers.

Click for more info!

-- Advertisement --

Five Email Mistakes You Should Avoid
Have you ever made any of these mistakes?

  • Forgotten to send an attachment you promised in a message
  • Replied-to-all, annoying everyone
  • Forgotten to Reply-to-All, annoying everyone
  • Sent emails using the wrong email account
  • Said something you oh-so-knew-better than to say

Send Guard can keep you looking good by saving you from yourself.

Tap here to download a fully-functional 30-day trial.

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
The Power Magazine for Microsoft Outlook and Exchange Users at OutlookPower.com
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Outlook is a trademark of Microsoft Corporation.
Editor's Login