Saturday 17 January 2009

GENERATING AN EMAIL LIST FROM ONCOURSE

I like to set up my own email lists for contacting students rather
than using IU's standard Oncourse software. Here is how to do that.


1. Download the roster from Oncourse. This will generate a *.csv
spreadsheet on your computer.

2. Download my template file from http://rasmusen.org/a/email.listblank.xls.

3. Copy two columns from your roster file to the email.listblank.xls
file--
student name, and userid.

4. Save email.listblank.xls as a plain text *.csv file.

5. Open email.listblank.csv with a text editor.

6. Delete all the commas, spaces (which are invisible), and "
quotation marks. Save as email.listblank.txt.

7. You will be left with a plain text file of email addresses all run
together and thus suitable for plugging into the TO: box for an email
program.

No comments: