Search OutlookPower's 8,351 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 (25 articles)
   How to separate email accounts and still manage them
   Reformatting contacts before moving from Excel to Outlook
   Dell tech support asks us for tech support
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
Can Outlook run when it's not running (and other mysteries)?
Exploring the dark side of social networks
How not to screw up when you send email
How to separate email accounts and still manage them
How to convert a PST file from an old format to a new format
Visnetic MailFlow can automate your organization's mail processing
How to make Outlook launch an app at a specific time?
OutlookPower News Center
Touch in Windows 7: Just for show?
Windows XP User: I'm No Thief
Windows 7 May Get Family Pack Discount
Microsoft Unleashes Five Service Packs for Its Enterprise Security Wares
Give an Old Desktop New Life
Europe won't pay more for Windows 7. Really!
IT wish list for SharePoint 2010: Keep it simple
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Eight steps to successful and reliable home backups
David Gewirtz Online: CNN commentary and analysis
DominoPower: What to look for in a Domino-based document management solution
-- 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 --

Automate Address Data entry using ADDRESSGRABBER
AddressGrabber Business captures contact name, email address and phone numbers from email signatures, Web pages, documents and automatically transfers them to Outlook contacts with one click!
  • Capture contacts instantly into Outlook - Save 80% data entry time
  • Remove duplicate contacts as and when you add them into Outlook
  • Capture contacts automatically into QuickBooks and FedEx as well


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