View University CalendarsView University DirectoriesSearch the SiteGo to the SitemapGo to the Homepage

Instructions for importing a list from Voyager to create a class list and/or an e-mail list using a Macintosh computer.

 

Creating a class list

Part 1: Voyager, creating the class list

  1. Login Voyager
  2. Choose Faculty Academic Services.
  3. Choose the Instructor Menu.
  4. From the Instructor menu, select the term and CRN you want a class list for.
  5. Choose View Class and Waiting List.
  6. Select class list or wait list. Your list appears.
  7. Scroll to the bottom of the report. Click Export Class List to Excel.
  8. Report will open in Excel.

Part 2: Saving the file in Excel

  1. Excel displays the file.
  2. Arrange and sort the list to your specification (click on desired column heading and choose Data-Sort, click OK. At the 'Sort Warning' window, click OK). Listing is now sorted by that column.
  3. Choose File-Save and save the file as you normally would. If you also want to make an e-mail list save the file a second time but this time choose File-Save As and change the format type to text (Tab delimited).
  4. Navigate to where you want to save the file.
  5. Click Save.
  6. Click Yes at the 'features not compatible' prompt.
  7. Close file.

Creating an e-mail list

Step 1: Importing the names

  1. Open the Addressbook. Click the addressbook from the dock.
  2. Choose -Import Addressbook.
  3. Choose Outlook Express.
  4. Click Ok.
  5. Click Ok.
  6. Choose from exported file.
  7. Click Ok.
  8. Click Ok.
  9. Navigate to where file is saved. Click Choose. Addresses are imported.
  10. Click Ok.

Step 2. Creating the Group.

  1. Select the names to be put into a group. To select multiple name hold down the Apple key and select each name.
  2. Choose File-New group from selection. Group is created.

Note, when addressing an e-mail to a group list if the To field is selected, the list when sent, will show everyone's name that is on that list. Another option is to change the To field to BCC. This will send the list as blind carbon copy to all members of the list thus no one will know who else the list was sent to.

Lawrence University, PO Box 599, Appleton, WI 54912 (920) 832-7000 Contact Lawrence