Table of Contents
What is Mail Merge? What are Merge Fields?Before you beginImport the DataCustomizing the EmailSending the EmailWhat is Mail Merge?
Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.
What are Merge Fields?
«Placeholders» --called merge fields--tell Word where in the document to include information from the data source. You work on the main document in Word, inserting «merge fields» for the personalized content you want to include. When the mail merge is complete, the merge document will generate a personalized version of itself for each name in the data source.
For Example: First Name in your Excel header may look like «First Name» in the email writeup. It will then get translated into the "Nancy" since Nancy is in the First Name column. Then Evan in the next email sent out, since Evan is next in the Excel file.
Import the Data
- Make sure your Excel data has a header
- Make sure your Excel data is correct and ready to send.
- Open Microsoft Word
- Open a Blank Document
- Click the tab Mailings
- Click the Start Mailing Merge option
- Click E-mail Messages
- Click Select Recipients
- Click Use an Existing List...
- Locate your Excel file you want to mail merge
- Select the file
- Click the Open button
- Confirm the sheet you want to pull the information from
- Click the OK button
Customizing the Email
- Click the Greeting Line option
- Create a greeting line you want
- Click the OK button
- Add text you want, like you would in Word.
- If you want to add a specific piece of data
- Click Insert Merge Field
- Choose the field you want to add
- That pulled data will be represented by «DATA»
- Once your email is ready, click Preview Results
This will add the data into the email.
Sending the Email
- Make sure your Outlook application is closed. Otherwise, you will send from the opened Outlook mailbox.
- Once you are ready to send and you have proofed the email, click the Finish & Merge option
- Click the Send Email Messages...
- Add a subject line
- Select how many records to send, this corresponds to the rows in your Excel file
- Click the OK button
- Your Outlook will launch
- Option the Outlook Profile you want to send the email from
- Click the OK button
- The email will send immediately, you will see the email in the sent folder