Search OutlookPower's 9,596 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
The strange case of Outlook losing notes and requiring passwords
Why I'm choosing to stick with Outlook 2007
Three ways to avoid email distraction and take back control of your time
Twenty ways to use email to commit career suicide
The two most motivational words in the English language
Diagnosing corrupted email headers
Email offenders
OutlookPower News Center
New Filing Assistant from Allometa
Dropbox bridges gaps in Microsoft's mobile sync
SmartBear Software Releases AQtime 7.0 Pro
6 Super Wi-Fi Tools for Windows
Microsoft Revives Windows 7 Family Pack Discount
Microsoft releases FixIt for critical flaw in 100 apps
M-Files Cloud Vault Easy, Hosted Document Management
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Smartphone smarts for a mobile world
David Gewirtz Online: CNN commentary and analysis
DominoPower: It's time for Lotus to double-down on Linux and open source
-- Advertisement --

Centrally managed library houses boilerplate template for repetitive person-to-person email
COPY-and-PASTE from SENT ITEMS is a crude approach to repetitive email tasks, yet we all do it at times. Now, a slick online alternative saves time for senders, assures brand consistency, and greatly improves the quality of outgoing written communications. This service is built around a powerful integrated mail-merge functionality and is super easy for users and administrators. Use it internally, with home-based employees, or externally with dealers, distributors, service-reps, etc.

Learn more and try our LIVE DEMO.
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