Mass Mailings

All @fairfield.edu email accounts are limited to 100 external recipients includes students in an hour except for pre-approved Resource Accounts.

To send a message to a large number of recipients quickly, you can use the email merge feature of Microsoft Word together with Excel and Outlook. Email merge works well for newsletters and announcements. Messages can be customized for each recipient.

Step-by-step guide

Prepare the recipients list

1. You should store all of the recipient's information in an Excel spreadsheet.
2. The first row of the spreadsheet should contain column headings such as First Name, Last Name, and Email Address.
3. Each recipient's email address must be in a column by itself without the full name, angle brackets, quote marks, or other special characters.

4. Each recipient's information must be listed on a separate row.
   Row and column example with column headings:

   First	Last	Email
   Jane	Smith	jane.smith@gmail.com
   John	Doe	jdoe@yahoo.com
   Robert	Roe	bob@msn.com

   
   EXCEL FILES MUST BE SAVED IN 2003 FORMAT

Prepare the email message

1. Start Microsoft Word and begin a new blank document.
2. Switch to the Mailings ribbon.
3. Click on the Start Mail Merge menu and select the E-Mail Messages option
4. Click on the Select Recipients menu and select the Use Existing List option.
5. Browse and select the Excel spreadsheet you created earlier, and then click on the Open button.
6. In the Select Table window, click on the name of the sheet that contains your recipient's information. Most likely on Sheet1.
   1. If you entered column headings in the first row of your spreadsheet, make sure the First row of data contains column headers option is checked.
   2. Click on the OK button.
7. Compose the body of your message using Word:
   • You can switch back to the Home ribbon to add formatting.
8. To customize the contents of your message with information from your spreadsheet:
   1. Position the cursor where you want to insert the data.
   2. Switch to the Mailings ribbon.
   3. Click on the Insert Merge Field menu and select the field containing the data you want to insert.
9. Save the body of the email message the same way you would save any other Word document.

Send the email messages

1. Switch to the Mailings ribbon.
2. Click on the Finish & Merge menu and select the Send E-Mail Messages option.
3. From the To drop-down menu, select the field containing the email address of each recipient.
4. In the Subject text box, enter the subject line used for the email message.
5. From the Mail format drop-down menu, select the HTML option.
6. For the Send records radio button, select the All option.
7. Click on the OK button to send the messages.

Related articles

• Page:
  Open a Public Folder in Outlook
• Page:
  Resource Account Creation Procedure
• Page:
  Create a Profile for Exchange (@fairfield.edu) in Outlook - Windows
• Page:
  Setup Exchange (@fairfield.edu) on Outlook 2019 - Mac OS X
• Page:
  Manage Your Outlook