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
Use Mail Merge to customize form letters
By Diane Poremsky

Nothing says "impersonal and uncaring" as much as form letter sent to a group of people, whether it's your annual Holiday letter to friends or a form sent to clients and potential clients. It doesn't matter whether it's a traditional mailed letter or sent via email, it's still impersonal. It doesn't have to be this way. Customizing form letters to make them appear more personal and directed specifically at the recipient isn't hard.

It's called Mail Merge, and you can do it right from Outlook using your contact data.

The first step is picking the contacts you want to include in the merge. You can hold the control or shift key as you select contacts or use custom views to display the contacts you want to use. This is a good reason to use categories--then you can group by category and select the contacts.

Next, select Tools->Mail Merge to open the Mail Merge dialog, and you're almost done. Choose whether to use all contact fields or only those fields in the view. Then choose the type of document to merge and select OK to complete the merge. The selected contacts are exported to a document called OMM.doc for Word to use as the data source.

Mail Merge tip 1: "Contact fields in the current view" means fields in the view, including any you need to scroll to see, not just the fields you can see on screen.

Mail Merge tip 2: You can save the data source document to use again and again, even if you didn't select the option on the mail merge dialog. Use search to find OMM*.doc and copy it to your documents directory.

All that's left to do now is prepare your form letter. If you're new to mail merge, use the Mail Merge Wizard to lead you through the final steps, using View->Task Pane to show the Mail Merge task pane.

If you're comfortable not using the wizard, use the Mail Merge toolbar to insert fields and the ABC button to display your data in the merge fields. When you're finished, send the document to the printer or email it.

Wasn't that easy?

Diane Poremsky is the president of CDOLive LLC and a Microsoft Outlook MVP. She's coauthor of Word 2002: The Complete Reference (Osborne, 2001) and Beginning Visual Basic 6 Application Development (for Wrox Press). 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 --

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

Personalized Emails Are Opened More
Create and send personalized, individually addressed copies of the same email to as many people as you want...using our easy Wizard Interface inside Outlook.

EmailMerge will help you make more sales. Send Personalized Business Emails, Holiday Greeting and Invites. EmailMerge will help you reach your customers, family, and friends in more personal and effective way. Supports Outlooks Contacts, Excel and Access files, delayed batch sending, multiple accounts and more within its easy to use Wizard interface.

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