hello listers
to begin with I have no great excel skills

What I am looking for is a macro that I can easily use to send mail to a list of users. I have made a web page that students sign up on: http://biosciences.utoledo.edu/prs, enter there info and, when they press submit, the data is saved to a text file that can be opened as a CSV file in Excel. I would like to have a macro go row by row, down the sheet, and extract the email from column G and insert that into a new email message, and also grab the students name from coulmn B. The CSV file is set up like this:
ID Fname Lname StudentID TransmitID Section email lecture DATE

Soon, we will add more columns to it to put student grades. Is it possable that the macro could also add up there grades and if they have an "A" it would send a msg saying that you're doing great or some thing or if they got a "D" it would say you might want to get help in class so the students will know how they're doing. Is this possable ??

Dale