Classic ASP ProfessionalFor advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
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.
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.
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.