auto email to less attendance students on every Monday on specific time.

[sarabjit]

Hello Everyone,

I have created an attendance sheet with formulas, protection and vba code to scan and to send emails who ever is short of attendance. I am going to share this sheet with everyone. Please study this sheet. Now, I want to write a code that can open this sheet automatically and can send emails automatically on ever Monday on specific time or on any other specified day and time. After sending the emails, it should automatically close the file also. I wanted to use user login with this but i don't know if it is possible, this is not the priority, but will be great if i can have something to authenticate. At this point I have put this sheet on server and have got an html code to call this file. This HTML file is available to all the tutors, when they click on it they get excel file to put an attendance. i am sharing that code also, which i got from internet. Its working fine for me. It works only on internet explorer. I don't know how to make it work on Mozilla.


Password to unprotect is = password.

Please let me know if anyone can make it work as per my requirement.

I shall be thankful.

Cheers

Sarab