auto mail

bspradeep · January 26th, 2004, 03:05 PM

HI,
I want to send auto mail for wishing a person on his birthday in an organization.The details is entered in the database and saved. The program(email) should interact with the database and send a mail to the person.

For ex:- Mr.XYZ's birthday is on 14-03-2004 then the program should send a mail wishing him Happy Birthday.

Plz help me.
pradeep

planoie · January 26th, 2004, 03:24 PM

You are going to have to do this with something running on a schedule. You could use a .vbs script and use the windows scheduler to schedule it to run every day. If you are using a database system that can run scheduled jobs (like MS-SQL server) then you could use the SQL scheduler to run a script in the DB.

Peter
------------------------------------------------------
Work smarter, not harder.