ASP / EMAIL

[Visitor]

I have employee table with fields, NAME, REVIEW_DATE, SUPERVISOR_EMAIL
Using ASPEMAIL, I want to setup to send an AUTO email to the SUPERVISOR
every year for each employee on their aniversary date (one year).
REVIEW_DATE IS FIXED for certain date, example like 01/01/2002,
Example:
I want to send an email to supervisor every on aniversary date,
first email on 01/01/2003 reminding the supervisor about employe aniversay date.
Next email on 01/01/2004 reminding the supervisor about next aniversay.
Next email on 01/01/2005 reminding the supervisor about next aniversay.
Next email on 01/01/2006 reminding the supervisor about next aniversay.
So on.............

Any ASP / EMAIL code help please. Thank you.

 

[ehsant]

Hi there ...
because ASP is a code that only and only runs on the server, you cant write a code that it automaticly runs and send the email.
the work you can do, is that on the pages which have a great number of hit on your site, like login page or so,
(not as welcome page because it will make your server busy)
put a code that checks the aniversary date and if that was the time, send the emails.
for sending email, you can use CDONTS from IIS and Exchange or there are some othe Objects that do the same like JMAIL or so...
if you need any other help, please let me know.
TNX.
E.T.