2) If you use Carlson LMS and you sent an email to your class previously using the Carlson LMS emailer in the Student Roster, you should have received a confirmation copy of your email. The confirmation copy has a list of email addresses the email went to. You can copy/paste that list into an email program (e.g. Thunderbird).
3). If you use Carlson LMS, you can go to the Section Management area of your course and download a copy of the Student Roster (which will contain a list of email addresses)
4) If you use WebCT/WebVista, and if WebVista is currently online and working, you can scrape an email list from your WebVista Section Grade Book. Instructions below.
Instructions for #4
In WebCT/WebVista Vista 4, go to the Teach tab.
On the left, under Instructor Tools, select the Grade Book
On the right, click the "Grade Book Options" button.
Select "Find Members" button and set the query for:
Column = DROPDATE (see picture here)
Condition = Blank
Checkmark "Roles"
Select the radio button "contain"
Select "Student"
Click the "Run Query" button.
You will be returned to the grade book. Scroll to the bottom and click the "Export to Spreadsheet" button. Keep the defaults. Open the spreadsheet in excel.
To make the email addresses ready for an email program, you need to put a comma or semi-colon between the email addresses.
Insert a new column after the USERID column called "Email Address."
Inside the Email Address column cells type the concatenate function in the first cell .... for example,
=CONCATENATE(B2,"@umn.edu,")
where B2 is the cell corresponding to the student's UserID
Then, copy the formula to the rest of the cells in the new column.
This should give you a column with the email addresses with a comma delimiter on the end. You should be able to copy/paste this column of values and put them into an email address field, e.g. GopherMail or Thunderbird.
TIP: If you like, you could import this spreadsheet BACK to the grade book and have a Email Address column in your WebVista Grade Book.
