MCCC Knowledge Base

Sending Email with Mail Merge for Advisors

2017

Sending Email with Mail Merge for Advisors

  1. Download an Excel file (.xls) from Starfish containing the students you will be contacting
    1. Log into Starfish
    2. Apply any necessary filters
      • i.e. Attribute = RCT
    3. Click Download
    4. When prompted, select 'Save As'
    5. Save as type = Excel (.xls) or (.xlsx)
    6. Note the file name and location as you will need it later.
  2. Open the Outlook client
    • Note: not the web version of email
  3. Open the letter you will be sending students (also referred to as the Merge Document) in Word
    • Example document attached to this article.
  4. If prompted, click Enable Content, on the yellow Security Warning
  5. Modify the document as needed. For example:
    • You should review the entire document and add/remove information as it applies to you and/or your advisees.
    • Add the majors you advise.
    • Add your campus.
    • Update your email
    • Add your signature.
  6. Select the Mailings Tab from the Ribbon
    •  
  7. Click Select Recipients > Use an Existing List...
  8. Select the file saved in step 1.f above and click  Open Button
  9. When prompted to select table, verify 'First row of data contains column headers is checked'.
  10. Click OK
  11. Click the  Preview Results  button (in the Mailings tab) to ensure the correct fields from the Excel file are being placed in the document.
    • You may click the navigation buttons (e.x. Right arrow ) to navigate through the records to verify.
  12. Click Finish & Merge > Send Email Messages...
    • Finish & Merge / Send Email Messages

  13. Verify To: field is set to email
  14. Enter a Subject line:
  15. Optional: select a limited number of records to send to
    • It is recommended you email no more than 200 individuals at a time. If your list of students exceeds 200 individuals, it is recommended you use the From: fields to select groups of 200 students
    • From field

  16. When you are ready to begin sending the messages, click  OK button
    • The messages will begin sending immediately
    • Messages will be sent from Outlook. You can verify messages sent in your Sent Items folder.
0 (0)
Article Rating (No Votes)
Rate this article
Attached Files (2)
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Related Articles RSS Feed
Manually Downloading the Outlook Address Book
Viewed 5976 times since Thu, Jun 30, 2016
Office 365 - Outlook for Windows and OWA - Calendar Best Practices
Viewed 15915 times since Tue, Dec 8, 2015
Adding an Additional Mailbox in Outlook
Viewed 108520 times since Thu, Jun 19, 2014
Share Your Default Calendar
Viewed 7302 times since Thu, Apr 16, 2015
Sending from or on behalf of another account
Viewed 35836 times since Fri, Sep 1, 2017
Secure File Transfer Outlook Rule
Viewed 6673 times since Thu, Jul 20, 2017
Sharing Contacts or a Contact List in Outlook (Email)
Viewed 129259 times since Wed, Mar 29, 2017
Set up Outlook for Android
Viewed 59875 times since Mon, Feb 19, 2018
Using Automatic Replies (Out of Office Messages) in Outlook
Viewed 7477 times since Thu, Jun 9, 2016
Faculty and Students - Outlook (Web Version) Address List
Viewed 514 times since Wed, Jun 22, 2022

Need Help?