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 windows computers.

 

Creating a class list

Part 1: Voyager, creating the class list

  1. Login to 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. Choose Open. File will open in Excel

Part 2: Saving the file in Excel

  1. 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.
  2. 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 file type to .csv (comma delimited).

Creating an e-mail list

Step 1: Importing the names

  1. Open Thunderbird.
  2. Open the Address book. Select Tools - Address Book.
  3. Select Tools - Import.
  4. Select Address book from the options. Click Next.
  5. Select Text file from the options. Click Next.
  6. Navigate to where you saved the .csv file. Change the files of type to All Files. Select it and click Open.
  7. Match up the fields. E-mail to E-mail, Name to Name. Click Ok. (File is imported.)
  8. Click Finish. (The imported file is now a new addressbook. You should see it in the folder list on the left. The next step is to create the list.)

Step 2. Creating the list

  1. From Thunderbird's Addressbook select the imported addressbook. Click New List.
  2. Enter a list name.
  3. Click Ok.
  4. The list is created inside the your imported address book. Click the "+" sign next to the imported address book. The list will appear below the imported address book.
  5. Drag names from the imported addressbook to the list. They are shown on the right if your imported addressbook is selected.
  6. To select multiple addresses, select your first address, hold down the Shift key, click on the last address.
  7. Double-click on the list name to verify the addresses have been copied to it.

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