Send Personalized E-Mails Using Word's Mail Merge Tool


SEND PERSONALIZED E-MAILS USING WORD’S MAIL MERGE TOOL
I frequently send e-mails to clients reminding them of deadlines or special services. To protect the recipients’ identities I use the Bcc (blind copy) in the address box. While that approach is OK, the message still appears somewhat like a cheesy broadside advertisement because the e-mails aren’t personalized with a Dear George Smith, for example. However, to personalize each one would take too much time. There’s got to be a better way. Can you help?

There is a better way. As you know, Outlook can use Word for word processing, and that gives you access to Word’s Mail Merge tool, which fortunately adapts itself easily to producing personalized e-mails as well as letters, envelopes and labels. And the good news is that the tool works the same as a standard Mail Merge and equally well in both Office 2007 and 2003. In other words, it lets you generate personalized e-mails, addressing them from a choice of contact lists—such as Outlook or an Excel spreadsheet, among others.

To launch Outlook’s Mail Merge, start by typing your message in Word and then, if you’re using Office 2007, click on the Mailings tab in the ribbon; if you’re using Word 2003, click on Tools, Letters and Mailings. The Mail Merge wizard screens look different in the 2003 and 2007 versions, but they contain practically the same instructions (see screenshots below).


Word 2007 Mail Merge


Word 2003 Mail Merge

Then just follow the wizard as it takes you through all the setup steps. When the wizard asks you to select the recipients of the e-mail, you have several choices: You can select them from your Outlook contacts list, an Excel spreadsheet, or you could type them in.

The next step is to add the appropriate fields that personalize the greeting (see screenshot below).


The Word 2007 screen


The Word 2003 screen

Once you click on OK, the fields for the greeting lines and any other information you added can be reviewed. When you’re satisfied, click on Finish and Send E-mail Messages. Outlook automatically takes it from there, adding the names and addresses for each message and sending them along.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.