Kellogg Information Systems (KIS)
Info For:
All | Faculty | Staff | Full-Time | Part-Time | EMBA | PhD | MSMS
Go Search

Office 2010: Outlook - Creating Course Roster Email Lists 
Audience: Faculty

Operating System: Windows 7;Windows Vista;Windows XP
Article Number: 464 .7.0

Updated: 1/24/2013 12:20 PM
Learn how to export your class roster and create an email Contact Group in Outlook.

Outlook Contact Groups

A Contact Group1 is a group of Contacts organized under one name. Messages sent to a Contact Group go to all recipients that are listed within the group. You can include Contact Groups in messages, task requests, meeting requests, and in other Contact Groups.

Copy Email Addressed from your Roster

  1. In your web browser, login to the Kellogg Student Rosters page.
  2. Select the term of your class (e.g. Winter 13).
  3. Select a course from the drop down menu, and ensure that the Class Roster option is selected for the report type. Click Submit. The class roster report will appear.
  4. Select the content for all numbered rows. To do this, click and hold to the left of number 1, drag down and to the right until you reach the end of the last email address, then let go. Hit CTRL-C to copy the text.

Prepare Email Addresses for Outlook

  1. Open Microsoft Excel.
  2. Click inside the first cell (A1), and hit CTRL-V to paste the class roster information.
  3. Find the column with the list of email addresses and click the column letter. This will select the entire column.
  4. Hit CTRL-H to open the Find and Replace window.
  5. In the Find text box, enter .edu
  6. In the Replace text box, enter .edu;
  7. Click Replace All.
  8. Click OK when complete and close the Find and Replace window.
  9. Now, right-click on the column letter that contains the email addresses and hit CTRL-C to copy.

Create an Outlook Contact group

  1. Open Outlook.
  2. Select the New Items button, then select More Items and click Contact Group.2
  3. In the Name field, enter a name for your list (e.g., ACCT-430-0 Section 41).
  4. Click the Add Members button and select From Outlook Contacts. The Select Members: Contacts window opens.
  5. At the bottom of the window, to the right of the Members button, click inside the field and hit CTRL-V. This will paste all of the student email addresses.
  6. Click OK to the close the window.
  7. Next, click Save and Close.

When creating email messages, you can input the name of the distribution list in the TO field to send a message to your entire class.

Note: In previous Outlook versions, this was known as a distribution list.

2 Alternatively, a Contact Group can be created by selecting Contacts in the Navigation Pane and clicking the New Contact Group button.