Written by The New Paperclip on June 8, 2007 – 10:15 pm
Do you have a message that you want to send to multiple contacts, but you don’t want to do the old BCC trick? Better yet… do you want to actually personalise the message for each recipient?
Instead of “Hi all”, what about “Hi Bill”, “Hi Jane” etc?
You can, with email merge in Word 2007.
Email merge works exactly the same as a standard mail merge… except for one big difference. Instead of printing individual letters or envelopes or labels… Word 2007 will generate individual emails, send them to your Outlook 2007 outbox, and then when you are next online in Outlook, Outlook will send each your personalised emails to each addressee.
Kicking off a email merge in Word 2007 is easy.
- Open up Word 2007
- Type your email in Word 2007
- Click on the “Mailings” tab in the ribbon
- In the “Start Mail Merge” grouping, click on the “Start Mail Merge” button. It will show a list of mail merge options available. You can choose Letters, E-Mail Messages, Envelopes, Labels or Directory. In this case as we want to send an email… click on “E-Mail Messages”

- Next you need to select the recipients of your email merge. These names could come from any number or sources… maybe an Excel 2007 spreadsheet? maybe your Outlook 2007 Contacts… or you could just type them yourself.
To do that, click on the “Select Recipients” box in the “Start Mail Merge” group. Either find your data source, your outlook contacts, or create a new list.
- If you want to edit any of the recipients in the list, now is the time to click on “Edit Recipient List” in the “Start Mail Merge” group.
- The next step is to add the appropriate fields to personalise the greeting, the recipients name, or to add any other piece of data you might have on the contact anywhere throughout your recipient list.
You can find the appropriate fields in the “Write & Insert Fields” group (still on the “Mailings” tab).
More than likely you will want to add at least a greeting line (Dear Bill… or something like that). To do that click on the “Greeting Line” button in the “Write & Insert Fields” group. The following dialog box appears

- Once you are happy with your greeting line format, click “OK”. Word 2007 will now drop the field into your document.
- Now you can preview your results to ensure that everyone’s name is coming up correctly. Click the “Preview Results” button in the “Preview Results” group… then use the forward and back arrows beside it to run through your recipient list.
- If you are happy with the preview, not is the time to finish things off and compete the merge. In the “Finish” group on the “Mailings tab” you will see a button called “Finish & Merge”. Click on it, and then click “Send E-mail Messages…”
- Now Word 2007 automatically generates all the individual emails, and sends them to your Outlook 2007 outbox (or your default email client).
- Open up Outlook or your email client, and watch all your emails be sent!
So there you have it… your 12 step guide to Email Merge in Word 2007!
’till next time,
TNP ![]()


What do you do if word does not seem to be linking to Outlook when you create this merge document and send it? I do not get any errors and when I check my out box or my sent box there is nothing there!
It appears there is something wrong and I don’t know where to start to fix the problem.
Please help if you can,
Thanks
Great. Everything works fine - as per your 12 step suggestion. Now, how do I attach another file to the e-mail. My data source is in Excel, not Outlook.
It works but not very good.
I and others on the web report formatting errors for workstations with out Office 2007 installed. I have been using Word for years to send our news letter via email merge and have never had trouble before.
Now when anyone without office 2007 or on Google and Yahoo mail accounts see a very messed up formatting challenged version of what was orig designed.
MICROSOFT PLEASE FIX THIS.
Also it appears that I am not the only one that has trouble with the whole process freezing. During the send routine it goes through between 200 to 350 emails and then freezes. I had a customer have the same trouble and called me to se if I knew why!
Now I have Microsoft Virtual PC installed on Vista In VPC I created a XP virtual session and on the Virtual XP installed my old copy of office 2003. Now I have to go to the Virtual Desktop in XP and launch an old copy of Office 2003 just to send my email newsletter every month. I am looking for alternatives.
While I can go through all the initial steps. Step 10 onwards doesn’t work as the option is grayed out.
I am using Windows Vista
Can we add multiple email addresses? i.e. “email1@home.com; email2@home.com” on our excel spreadsheet.