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
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