-
Added (jobs): Automating Emails from Excel
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules