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

You are probably better off using some kind of Batch job on the server run under a scheduler so that it executes every day for example. Windows Scripting Host (WSH) is very similar to ASP - both being based in VB - and should provide what you need.

You need to write a windows service which do the job for you. for example you have an employee table in your database(which includes DOB field). Now the windows service will fetch the record from database and send email to that particular person whose date of birth falls on that particular day.

Aftab Satti

Hii Pradeep,

You can do this by writing a vbs code and schedule it on the server so that the code runs on the specified time everyday. The code can be written in asp, but since asp pages can not be scheduled, u have to write them in vbs.

Sorry if this was a late reply... pradeeps query post was wayback in 2004. By this time he must have had his application running successfully :)