Mail Merge lets you send one email to many people, with each message addressed to the recipient by name. You write the email once in Word and pull names and other details from an Excel sheet. The emails are sent through your Titan Mail account in Outlook.
Before you begin
You need the following on your computer:
- Microsoft Word, Excel and Outlook (desktop versions)
- Your Titan Mail account added to Outlook and set as the default account for sending email
If you have not added Titan Mail to Outlook yet, follow this first.
Mail Merge works with the desktop versions of Word, Excel and Outlook. It does not work in the web or mobile versions.
Create your recipient list in Excel
Your recipient list is an Excel sheet with one row per person. Skip this section if you already have a list with a column for email addresses.
- Open Excel.
- On the start screen, click Blank workbook.
- In row 1, type a heading in each column: Name, Surname, Date, Item and Email address.
-
Starting in row 2, type the details for each recipient. Use one row per person.
- Click File.
- Click Save As.
- Choose a folder you can find easily.
- In File name, type a name such as Recipients.
- Click Save.
- Close the workbook. Word cannot read the list while it is open in Excel.
Start the mail merge in Word
Choose the email type
- Open Word.
- On the start screen, click Blank document.
- In the top menu, click the Mailings tab.
- On the Mailings tab, click Start Mail Merge.
-
In the list, click E-Mail Messages.
Connect your Excel list
- On the Mailings tab, click Select Recipients.
- Click Use an Existing List.
- In the window that opens, find your Excel file and click it.
- Click Open.
- In the Select Table window, click the sheet that contains your list. This is usually Sheet1$. (Sheet1$ is the default name of the first sheet in an Excel file.)
- Select the First row of data contains column headers checkbox.
-
Click OK.
Your list is now connected. The Insert Merge Field button on the Mailings tab is now available.
Write your email and add merge fields
A merge field is a placeholder, such as «Name», that Word replaces with each recipient’s details when the email is sent.
- In your Word document, click in the page and type your email message. For example: Dear, followed by a space.
- Place your cursor where the recipient’s name should appear.
- On the Mailings tab, click Insert Merge Field.
- In the list, click Name. The placeholder «Name» appears in your email.
-
Repeat steps 2 to 4 for each detail you want to personalize, such as Surname, Date or Item.
Your email template is ready.
Preview and send your emails
Preview your email
- On the Mailings tab, click Preview Results. The placeholders change to the first recipient’s details.
- Next to Preview Results, click the forward arrow to check the next recipient.
-
Check that each name and detail appears correctly.
Send your emails
Emails are sent as soon as you click OK in step 7 below, and you cannot take them back. To test first, make a list that contains only your own email address, then complete these steps.
- On the Mailings tab, click Finish & Merge.
- Click Send Email Messages. The Merge to E-mail window opens.
- In To, select the column that contains your recipients’ email addresses. In this example, it is Email address.
- In Subject line, type the subject of your email.
- In Mail format, select HTML Message. This keeps your formatting, images and links.
- Under Send records, select All.
-
Click OK.
What you will see when it is done
Word sends each email through your Titan Mail account in Outlook. You can see the sent emails in the Sent Items folder in Outlook. Each recipient receives a message addressed to them by name.
Troubleshooting
Problem: You cannot click Send Email Messages under Finish & Merge.
Cause: Outlook is not set up on your computer, or it is not your default email program.
Fix: Add your Titan Mail account to Outlook and set Outlook as your default email program in your computer’s settings. Then reopen Word and try again.
Problem: Your recipients receive the email from an address that is not your Titan Mail address.
Cause: Another account in Outlook is set as the default for sending.
Fix: In Outlook, set your Titan Mail account as the default account. Then run the merge again.
Problem: The merge finishes, but the emails stay in the Outbox folder in Outlook.
Cause: Outlook cannot connect to your Titan Mail account, or it is working offline.
Fix: Check your internet connection, make sure Outlook is not in offline mode, and send a normal email from Outlook to confirm it works.