Creating letters and envelopes may seem like an obvious use of mail merge. But we aren't limited just to correspondence that is printed on paper. We can also use mail merge to create and send email messages. This process is similar to creating letters and will involve using Microsoft Word, Excel, and Outlook.
We have already sent letters to everyone who submitted a proposal for the conference. We are now going to send email messages to these people letting them know if their proposal was accepted or rejected.
Creating the document - I DON'T LOVE THIS H2
The first set of email messages we send will be to the people whose proposals were not accepted. To create these messages, we will begin with a Microsoft Word document that contains the letterhead of the Midwest Cycling Cooperative as well as the standard text. We do not want to overwrite this standard message with our mail merge, so we will save it as a new file.
NOTE: We will use "MM" at the end of the file name to show that this is indeed a mail merge document and will have a connection to a data source.
To open the Unaccepted document,
Navigate to the correct drive, Double-click Unaccepted.docx
To begin saving the document with a new name, in Microsoft Word,
Click File, Click Save As
To select the current name, in the name field,
Click the current name
To rename the file, in the name field, type:
Unaccepted-MM.docx Enter key
Examining the data source
Now that the message has been saved with a new name, let's examine the data source. When we created the letters and envelopes, we used an Excel worksheet named Applicants as the data source. This worksheet was part of a workbook named Conference.xlsx. For the email messages, we will use the second worksheet in this workbook, Reviewed. This worksheet contains all of the conference proposals with a column indicating if the proposal was accepted.
To open the Conference workbook,
Navigate to the correct drive, Double-click Conference.xlsx
To move to the Reviewed worksheet, at the bottom of the workbook,
Click the Reviewed tab
The Reviewed worksheet contains all of the information for the submitted proposals. Column J indicates if the proposal was accepted. In addition, the accepted entries have been sorted into categories (column K) and assigned a room (column L) and a time (column M).
Close the Excel workbook.
Creating a mail merge with filtered data
The email messages we are going to send will be to the people whose proposals were not accepted. Our source file will have to be filtered to show only those entries. This can be done as part of the mail merge process.
To move to the Mailings tab, on the ribbon,
Click the Mailings tab
To begin the mail merge for email messages, in the Start Mail Merge group,
Click , Click E-mail Messages
To begin selecting the data source, in the Start Mail Merge group,
Click , Click Using an Existing List...
To choose the correct file,
Navigate to the folder containing the exercise files, Double-click Conference.xlsx
To choose the correct worksheet, in the Select Table dialog box,
Click Reviewed, Click
The correct worksheet is now ready to be merged with the document.
Because we are sending this email only to the people whose proposals were not accepted, we need to filter the source data. We can do that now.
To open the Mail Merge Recipients dialog box, in the Start Mail Merge group,
The Mail Merge Recipients dialog box opens:
This dialog box shows all of the fields and entries in the source data worksheet. Using the built-in options we can filter or sort our source data. We could also find a specific recipient or duplicate records. Let's filter the data now.
To see the Accepted column, in the Mail Merge Recipients dialog box,
Scroll to the right
To filter the Accepted column,
Click , Click No
The list adjusts and we see the five unaccepted proposals.
To confirm the filter, in the Mail Merge Recipients dialog box,
There is no visible change to the email document. However, when we begin adding merge fields, only the recipients with unaccepted proposals will be available to us.
Because this is an email message, not a letter, there is no need for an inside address. We will add a greeting line.
To correctly place the cursor, in the email,
Click below the letterhead
To open the Insert Greeting Line dialog box, in the Write & Insert Fields group,
To accept the defaults and insert the greeting line, in the Insert Greeting Line dialog box,
To preview the results, in the Preview Results group,
To review the other email messages, in the Preview Results group,
Changing Outlook to offline mode (DONT LOVE THIS H2)
When sending merged emails it may be advisable to take Microsoft Outlook into offline mode, review the emails, then return to online mode to send them. This will give an extra level of protection from accidentally sending emails with typos or misinformation or sending emails to the wrong people.
Open Microsoft Outlook.
To move to the Send/Receive tab, on the ribbon,
Click the Send/Receive tab
To change to offline mode, in the Preferences group,
In Outlook the status bar now indicates that we're working offline.
When working in offline mode, all the editing takes place on your local installation of Outlook. No messages will be sent or received until we return to online mode.
Let's return to Word and complete the mail merge.
Completing the mail merge in offline mode
Now that we are working in offline mode, we can return to Word and complete the mail merge.
Return to Word.
To open the Merge to E-mail dialog box, in the Finish group,
Click , Click Send Email Messages...
The Merge to E-mail dialog box opens:
This dialog box allows us to choose which field to use to send the email. In our case, we want to use the Email field. We can also add a subject line and choose the mail format. An option to choose which records to send is on the bottom half of the dialog box. We want to add a subject line and then accept the defaults.
To add a subject line, in the Subject line field, type:
Thank you for your proposal
To accept the defaults and subject line, in the Merge to E-mail dialog box,
You may see some flashing on your screen, but for the most part, there is no visible change to the Word document.
Because Outlook is currently in offline mode, the messages have not been sent. They are waiting in the Outbox. We can open and make changes to the message before returning to online mode and sending them.
Return to Outlook.
To view the messages in the Outbox, in the folder list,
There are five email messages in the Outbox:
NOTE: For demonstration purposes, many of the recipients share email addresses.
At this point, we could edit individual email messages or even delete messages we don't want to send. Let's make a quick addition to one of the messages.
To open the first email in the Outbox,
Double-click the first email
To position the cursor,
Click at the end of the word "Committee," press: Enter key
To add the postscript, type:
It was nice to see you at the regional conference.
To close the email message,
To accept the changes, in the Microsoft Outlook dialog box,
Now that all of the edits have been made and saved, we can return to online mode. When the Work Offline button is toggled off, the messages will quickly be sent.
To return to online mode, in the Preferences group,
After a moment or two, the messages are sent and the Outbox is empty.
Let's check the Sent Items folder to see that the messages were sent.
To examine the Sent Items folder, in the folder list,
Click Sent Items
The five emails are in the Sent Items folder and our mail merge is complete.