I'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.
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'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 am currently developing a final year project which is a web based
tracking system tracking exam questions. I am using IIS as the
server, MS access for the database, and ASP with VBScript for the
scripting side of things.
One of the things I want to do would be to e-mail a user/moderator
whenever a exam question is edited/completed/updated. does anyone have
any previous expierence in this? i don't even know where to start.
What is the asp code variable for System Date and System Time? Are they built-in system variables, or is there some code involved to return the values?
View Replies View RelatedI'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.
I am working on asp and ms sql.
I have created a table called as 'usertable' in ms sql database. The columns in 'usertable' are username, loginid, password. The record gets added to this table, when a new user makes a fresh registration.
Eg: username = 'david'
loginid='daveuser'
password='newpass'
So My question is whenever a new user is added to a table, an automatic mail should come to me 'pra123@yahoo.com' mentioning that a new user is added to table ALONG WITH HIS USERNAME, LOGINID, PASSWORD.
All this information should come to my email account automatically. So how to write ASP Code for this.
I need to some how do the following and if anyone can help me or point me in the right direction I would appreciate it very much.
I have a form that the user would fill out. When he/she clicks submit it goes into another page that reviews the information that the user typed in the previous form. If all of the information is good for the user there's another button in that page that they would have to click.
This is what I want to happen after they click on this button. I want to record the data in a SQL database, which I know how to do that, but what I want to happen automatically right after inserting the data in the SQL database is that I want the same data to be carried over to another page where there'll be another form and want that data to be populated in this new form. How do I do that?
is it possiable in run some automatic checkups on the server every X time or every time (with no reaction with the user). I need to run all the time checkups on the sql database and check values of some column.
View Replies View RelatedI would like to backup the Remote Access database from a link on my asp application . Is it possible ?For instance, there would be a menu which once clicked will initiate login/password and ftp server, get the database and rename it with currentdate, close the connexion ?
View Replies View RelatedI want to add code to the URL so on click will be performed login action with some username and password (ex. h t t p : / / w w w . s o m e - s i t e . c o m /login&username=USER&password=PASS)
I think I wrote total nonsense, but I think you know what I am talking about
If someone want to help me here is that site I want to perform auto login: ...
if there is a way to have a page print automatically, with no dialog box when the page loads, using VBScript or Javascript. This will be an intranet application, running in IE6. I will have control over the browser settings, so those wont be a problem.
View Replies View RelatedAs u see that in yahoo messanger it provide facility for auto fill login and password for specific system. If we want to see our yahoo messanger in my personal sysem then we dont require to fill this user id and password. It automatically fills user id and password. I want to do it in asp.
View Replies View RelatedIs there any way to create automatic generation number like, INW001.......INW002.... ans so on without using any code in ms-access using "autonumber" type with default value.
or
Can you give me the code for creating automatic generation of numbers for a column IDNO , using alphanumeric.
Eg: INW001 , Next should be INW002 ,....... INW010 and so on
where I can get a script which will automatically print a page when its entered or when a form has been submitted. Ive tried to find a script to do such a fing but I really cant find anything to support it.
View Replies View RelatedIs there a way to automatically execute code in ASP? I need to send reminders for one my applications and need some suggestions . how I can send reminder emails automatically.
View Replies View RelatedI have a database that displays an editable record, with buttons for changing to different records. I was wondering if there was a way to store a template email, and have a link on the page that, when clicked, fills the records info into the email and sends it?
View Replies View RelatedI want to know if there is a possibility of mailing the iis log files automatically,say on a daily basis. The problem i am facing now is that my web host is very busy and i need to send dozens of mails to remind him. Also tell me the security previlages needed to execute the script so that i can convey the same to my web host....
And last but not the least can we develop this script with windows nt workstation + iis 4 wihout smtp.
I have created a Store front with .asp & access and I would like to setup something that emails all my users on my mailing list with a Dymanic email with the weeks specials.
But I would like it to happen automatically without any user interaction, say I would like to send it all the users @ 12.00am every monday.
How can this be done?
i want to know that how can i send automatically daily newsletter to my users.
i have started a newsletter service recently and want that everyday newsletter from database shall be sent to the users.
i also want to send newsletter on particular date in future as per selection made by the users themselves.
how can i Create daynamic pages or static pages Automatic .?
i have a problem with my website i want Create page asp classic to every member
The page name equal the member name
www.Micrsoft.com/Ashraf.asp
If i have 3000 members in my website it's possible to generate 3000 pages for everymember Automatic and if it is possible how can i do this ??
my Tec. are ASp classic and java script ..
I want to send customers and automatecly generated email once they submit a form/place order. I've been searching the net for a whille but I haven't been able to find any usefull information.
View Replies View RelatedI am having problems sending emails via the CDO.Message object from an
ASP script which was working fine. On the server I can still send
emails via the CDO.Message from a .vbs script executed on the desktop.
If I pause the SMTP service I can see mails queuing up from the .vbs
script but the ASP script no longer generates emails, nor does it error
when it creates the object.
Could this be a permissions problem? No IIS settings have changed, but
the server downloads automatic Windows updates.
Does anyone know how to setup an automatic mailer to members in a database at the end of the month?
View Replies View RelatedI'm trying to automatically submit a form to another ASP page after
some <input> fields values are filled by ASP.
I know I can do it using javascript, but is there a way to
automatically submit the form using VBscript? Code:
I need to build code to download automatically image to my local disk.
somethink like
i will specify url in code and it fetches image from that location and save
in my local disk.
for example
http://www.xyz.com/images/test.jpg
and it will store test.jpg in my local folder.
how to achieve this?