macro needed

D

DaleL

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 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 page and extract the email from column G
and insert that in to an email and also 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 grade and if they have
an "A" it would send a msg saying that your 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 there doing is this possable ??

Dale
 
D

DaleL

anyone want to take a stab at this or can point me to a place to get
some thing like this ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top