How do I this reminder? An applicant has submitted a leave application on 1 Jan 2005. If superior didn't approve / reject that leave application, a reminder will be sent to that superior again.
I already have the code on sending email but just wonder what code should I have to tell the system to automatically, run a code in certain time like the above case. I think I need my code should be in my global.asa file, isn't it?
I don't necessarily need code here, just some guidance to my thought process.
I have built a system for a hospital where users can sign up for classes that the hospital offers. Now, I want to be able to send the users a reminder email a day or so before the event/class. In the database, I have all the user's info in one table. Another table holds the registrations with keys to the user table and the key to the table that has a listing of the classes.
How do I now go about automatically looking through the class table to find out if there is a class in the next 24 hours, and then send an email to all the people registered for that class?
I have done out an online booking system.. but I need to add an extra feature whereby an e-mail reminder could be generated automatically(without me clicking anything) to the person who had make a booking 30 mins from his booking time.
I really have no clue n dun know what should I use to send an automated e-mail reminder. Can anyone teach me the steps to do so ? I 'm using asp and access database and is using windows 2000 .
I want to add an event reminder email feature that will go to the users that have already signed for the event a day before.
Can someone please help me as to how to start on this code?
This message is being brought to you by a few of your friendly neighborhood ASP programming solution providers:
Please attempt to solve your own problems before posting to Sitepoint. I know I (and other persons who will remain anonymous) find it a little irritating when one (or more) of the following happens:
1) We can type your question into Google and the answer is the first hit that comes up.
1.1) We can type your question into Sitepoint's search and the answer is the first hit that comes up.
2) Your question is answered two posts below your question.
3) The answer requires merely looking up the appropriate object/function in the ASP/VBScript references. *
4) Two or three minutes after posting your question, you post "Oh, nevermind, I got it." without even referencing the solution so other people with the same question will know how you did it.
* Note that we will be VERY happy to provide you with links to these kinds of references (and indeed already have in the Important ASP Resources thread - which happens to be marked important twice) upon your request (I know of at least one individual who links these references in his signature also).
Now, please don't think that I'm ranting and raving. I'm just trying to inform those persons who do the above on a regular basis. It grows tiresome when I login for the day and all 5 new posts are questions that are easily answered with a simple link that could have been found if the one who posted the question would have spent 30 seconds researching his/her problem.
Mentors, Advisors, and Sitepoint Team Members:
If the opinions of this post are contrary to that of Sitepoint, please let us know. I would suspect that you would like us to spend our time on questions that are not easily answered instead of just repeating information which is already easily accessible.
I just started learning ASP and I need to set up a very basic password reminder service for my website. Basically I just want the user to input their email address and get an email with their password sent to them.
View Replies View RelatedI've read the thread on how to design an automatic email reminder system, but does anyone have any tutorials or code on how to set it up using Access 2000 and/or SQL Server?
There are no articles on the net (that I could find) related to automatically sending a user an email at a set date and time from 1 table of a database.
From what I can gather, I may need to use a stored procedure, but there's no tutorial on how to design or implement this.
I'm trying to create a section of a website which will automatically show who has a birthday that week. I'm trying to find the best way to do it to create the least amounts of work on the server each time this page is loaded. Code:
View Replies View RelatedI have an online classifeds website and would like to send automatic reminder emails to advertisers 3 days before their advertisement expires.
I am able to send emails via CDONTS from a form but are unsure how to extract the date details from the database 3 days from the renewal date and send an email to all relevant advertisers . I have an Access database attached to the web pages.
I want to send the registerd users on my web site emails on a specific time automatically for example: a birthdate reminder.
But I need this to be done automatically when the time reached as they specified in the registeration form. Others said to me that the only available ways is to make an application for this, and make it run forever on the server to check the DB, and when the time reached it sends the reminders.
I've already retrieved the users password from the database - I just
need to send it to the email address entered.
From reading many posts, I need a server-side script and rather not
use form mailto: nor use javascript on the users PC.