Community College of Allegheny County Knowledge

English (US)
Log In
Home
Software & Applications
Accounts Blackboard Classroom & Other Spaces Computers & Hardware Communications Enrollment & Student Services Freshservice Human Resources Security Software & Applications Student Areas and Services Student Types Websites & Mobile Apps Wireless & Wired Connections & Networking
Microsoft 365 (Office)
Accounts Blackboard Classroom & Other Spaces Computers & Hardware Communications Enrollment & Student Services Freshservice Human Resources Security Software & Applications Student Areas and Services Student Types Websites & Mobile Apps Wireless & Wired Connections & Networking
Outlook
Microsoft Office App Outlook PowerPoint Word
Print Copy Link Hide

Table of Contents

Related Articles

Keywords

Table of Contents

What is Mail Merge?What are Merge Fields?Before you beginImport the DataCustomizing the EmailSending the Email
Delete

Before you begin:

Mail merge is currently only available in Classic Outlook. 

  • You must have your Excel data completed with information in the correct cells and a header at the top of the worksheet.
  • Check with IT to make sure the email address is allowed to bulk send emails.
  • You must have the Outlook profile setup for the email that is bulk sending. -  Adding another Profile to Outlook 
  • Different versions of Outlook may have differing steps. To know which version of Outlook you are using, you can use the info provided in the Microsoft article "What version of Outlook do I have?".
  • The latest information about Mail Merge can be found on Microsoft's website. 

What 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, such as 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. 

Classic Outlook

Import the Data

  1. Make sure your Excel data has a header
  2. Make sure your Excel data is correct and ready to send.
  3. Open Microsoft Word
  4. Open a Blank Document
  5. Click the tab Mailings
  6. Click the Start Mailing Merge option
  7. Click E-mail Messages
  8. Click Select Recipients
  9. Click Use an Existing List...
  10. Locate your Excel file you want to mail merge
  11. Select the file
  12. Click the Open button
  13. Confirm the sheet you want to pull the information from
  14. Click the OK button


Customizing the Email

  1. Click the Greeting Line option
  2. Create a greeting line you want
  3. Click the OK button
  4. Add text you want, like you would in Word.
  5. If you want to add a specific piece of data
    1. Click Insert Merge Field
    2. Choose the field you want to add
    3. That pulled data will be represented by «DATA»
  6. Once your email is ready, click Preview Results
    This will add the data into the email.

Sending the Email

  1. Make sure your Outlook application is closed. Otherwise, you will send from the opened Outlook mailbox.
  2. Once you are ready to send and you have proofed the email, click the Finish & Merge option
  3. Click the Send Email Messages...
  4. Add a subject line
  5. Select how many records to send, this corresponds to the rows in your Excel file
  6. Click the OK button
  7. Your Outlook will launch
  8. Option the Outlook Profile you want to send the email from
  9. Click the OK button
  10. .The email will send immediately, and you will be able to see the sent email in the sent folder.
Delete


New Outlook

Delete

Mail Merge is only compatible with Classic Outlook

If you have switched to the New Outlook and want to use mail merge, you can switch back to Classic Outlook using the instructions found on Microsoft's website.


Delete

Currently, New Outlook's 'Start Mail Merge' option does not work the same as 'mail merge' in Classic Outlook.

The Start Mail Merge' option, available in the send drop-down menu when starting a new email, sends the same email to multiple recipients as separate emails. There are currently no personalisation options when doing this, but the emails will send individually to each recipient from Outlook and the recipient will only be able to see the individual email sent directly to them. 

This is similar to BCCing all the recipients on an email. 




Delete