Wrox Programmer Forums
|
Classic ASP Professional For 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
 
Old January 17th, 2004, 04:24 PM
Authorized User
 
Join Date: Jul 2003
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default Send Auto Mail for Birthday wishes

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

 
Old January 17th, 2004, 08:16 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.
 
Old February 28th, 2007, 12:47 AM
Registered User
 
Join Date: Feb 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to aftabsatti
Default

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
 
Old February 28th, 2007, 06:07 AM
Authorized User
 
Join Date: Jan 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old February 28th, 2007, 06:13 AM
Authorized User
 
Join Date: Jan 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Send mail and attachments with PHP mail function Lofa Beginning PHP 1 June 2nd, 2008 03:24 PM
How to send a auto confirmation mail?? silu95421 Classic ASP Databases 0 October 27th, 2007 04:46 AM
Auto send email from command button underscore10304 Access VBA 3 September 26th, 2006 06:41 AM
auto send an emal Pavel Kadera Excel VBA 1 February 7th, 2005 12:48 PM
auto mail bspradeep Classic ASP Professional 1 January 26th, 2004 03:24 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.