|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
-- Advertisement --
ONLINE GROUP CALENDAR - FOR UP TO 100 OF YOUR CLOSEST FRIENDS
Stay organized and in control with 24/7 access to all of your important events, projects and files --whether you're at work, at home or on the road.
You can share your calendar, projects and files so everyone in your office is up to date. Plus, search your entire group to find times when everyone is available to meet, manage company resources and much more.
Organize your entire team for as low as $9.95 per year (and yes, that's where the decimal place is supposed to be!)
Tap here to get started right away. |
-- Advertisement --
Planning Exchange upgrade? Must-read report on compelling alternatives.
Exchange 2007 comes with a challenging adoption path. Plus, it's still plagued by performance issues, a closed database architecture driving complexity around backup and high availability, and high storage costs.
This report documents cost-effective, drop-in Exchange alternatives with high availability and archiving, unlimited mailbox size, and support for new devices such as BlackBerry.
Download your copy here. |
|
|
|
The Power Magazine for Microsoft Outlook and Exchange Users at OutlookPower.com
Copyright © 1998-2008, ZATZ Publishing. All rights reserved worldwide. Outlook is a trademark of Microsoft Corporation.
|
|
|
|
|
|
|