we have an Access database of our clients. It has fields for email addresses and date of expiry of their rents. I would like to write an application that would email our clients automatically according to the dates in the database fields, giving notice that their rent is about to expire like for example, within one month.
I just would like to ask if you could somehow give me some idea or point me to a website that will give me insights. Thanks very much indeed and hoping for your kind response.
using asp and vbscript is it possible to send auto emails to the engineers who r assigned that work if the text box contains their name and we can also retreive their email ids.how can u send auto emails to them by clicking a button on the asp form?
I have my edit page set so that, at a later date when payment comes in, I change the field "Confirmation of Funds" to Yes, which has a value of 1, which automatically sends an email to the customer whose funds I've received.
The problem is, if I go into the edit page later, to change an address or whatever, the email will get sent again, since the Confirmation of Funds field is still set to 1.
Is there a code I can stick in, after the code which sends the email, that will change the Confirmation of Funds field to 3, which I have as "Email Sent"? I already have that as a selection in my dropdown box, but I need to automatically change it after the email is sent.
I'm thinking something along the lines of
If COnfirmation of Funds = 1 Then Confirmation of Funds = 3 End If
Obviously that's wrong (I even tried it!) Can someone give me the proper syntax?
I am trying to add to a web site I am currently designing the function of automatic email sending. I want users to be able to sign up to a mailing list by completing a form (easy enough) and when they click 'Submit', the information is sent to my clients email address. I can quite happily programme everything described here and to auto launch the users email editor (Outlook/Thunderbird etc) with Subject and Body automatically completed but cannot send the information WITHOUT launching the email editor! I see this function on many web sites - no fuss, not even having to click the SEND button, just Submit and it's gone! This is obviously important for people with hotmail accounts etc who don't use Outlook/Thunderbird.
i required to auto send confirmation email after user registered..(like registration process in aspFree)...I read a lot n the solution is by using CDOSYS...i've found one example of the cdosys script...but i need some explanation on how to test it in localhost...how do we know its work or not...or is there any subtitute from using cdosys for sending email to user?
1st, i want to auto check my db to see if there's any mails to be sent on that day, at 12am everyday... i should create a batch file or create a asp script and use vbscript to call my asp file? How to create a batch file?
2nd, i go a search function..
In my db, i got a column with data like this "a , b , c" When the user entered "a", i want the information that have "a" in that coulmn to be taken out... i want an exact match of the word (seperated by the comma).. But when i search, how do i seperate the data in the column by a comma to see if i have an exact match?
ken any 1 enlighten me on wat to do for the following:
im suppose to allow user to enter their particulars in this registration for, following which Im suppose to auto generate a password and email it to them at the same time(after they have submitted their registration form).
point me to some resources about Email Auto Verification. I'm using ASP.What my system is doing is after the user sign up, my system need to send an email automatically back to the user's email. The user only can login after he receives that email from our system. This is to make sure the email he keys in is valid.
Set cdoMessage = Server.CreateObject("CDO.Message") Set cdoMessage.Configuration = cdoConfig cdoMessage.From = "admin@nyc-discusfanatics.com" cdoMessage.To = strEmail cdoMessage.Subject = "NYC-Discusfanatics.com User Registration" cdoMessage.HTMLBody = "<html>" &_ "<body>" &_ "Hello "&strUName&"<br/><br/>" &_ "Thank you for registrating with NYC-DiscusFanatics.com Please activate your account by clicking the link below.<br/><br/>" &_ "<a href='http://www.nyc-discusfanatics.com/face/dragonball/AccountActivate.asp?UserID="&strID&"'>Activate my account.</a>" &_ "<br/><br/>Thanks for your registration." &_ "<br/><br/><br/>Vincent" &_ "<br/><br/>Administrator of NYC-Discusfanatics.com" &_ "</body>" &_ "</html>" cdoMessage.Send Set cdoMessage = Nothing Set cdoConfig = Nothing
I got return email that the mail fail to deliever to AOL user. I assuming AOL email doesn't accept ASP script embedded in the email?
i have a page with top frame (html) and bottom frame (asp)the top frame come with choices and then submit value to bottom asp page by submit button.how can i do it if i wish the bottom asp to run automatically in specific value when the html is loaded.then the user can change the choices after.
Is it possible in ASP to have an Auto Fill option? For instance, if I am typing in a name and I type in the first few characters, can ASP recognize a similar name in the database and begin filling in the rest of a possible match?
ive got an online system which allows people to enter info into a database about an absence request they have - at the same time this emails the person in charge of absences.
The form is setup now but to make it easier i want to alter the "Name" and "email" fields so they require no filling in ie - a staff members name will be chosen from a drop down list (ive done this bit fine) and then once this is done the relevant email for this person is automatically placed in the email field. This bit i am struggling with - anyone any ideas how this can be done??
does anyone in here got an idea on how to automatically send an email message once a person signs up for a website? i'm doing a small website right now and if a person signs up on the website details about the non profit organization would be send automatically to their email.
I need to be able to autoexecute an asp page from a batch file that is placed in the windows scheduler.
I can execute the page fine, but I can't get past the authentication. How do I pass the username and password to windows via the URL automatically so this can be done without any user action? This is not a https but it uses integrated windows authentication.
I work for a large company and the outside supervisors are not that computer savy. The simpler the better. Each supervisor has 15 employees that he must assign work for each day(Monday through Friday and sometimes Saturday).
I am trying to create this so they can click on a button it will add 15 new records to Table A that are copied from the day before. Then they just have to update the new records with today's LocDate and a new location if needed. Code:
I have a an url to file in one page and when user clicks, it takees them to another page, say url.asp?ID=...
On this page i want the download to that file to start automatically. the purpose of this page is to record the number of file downloads. is this possible in asp, or is there a better way of doing this?
I would like to write an ASP script which will auto-login me to a Yahoo account or some user account which needs a username and a password. How can I make this possible using ASP?Or is there any way to get auto-login working?
How can you get cursor to "jump" from the first field that has focus onto the following one and so on, and is it possible to do so if fields sometimes might be empty and if so how would I take care of that?And is it possible to make autotabbing if the field is not a set lenght, I have only come accross examples where the field is expecting to receive a certain number of characters?!!! Can you use the option of auto tabbing only for input field or it can be done for select options as well?
I am currently developing a web form for the transfer of assets between departments, which will store information in an Access database. I currently have the form created and I am working getting the transaction processing portion of it going.
Basically, there is a minimal amount of information that needs to be entered into the form and I would like the rest of the information to auto-fill. So for instance, I would enter the asset number of the asset to be transferred, and said asset's serial number and description would fill in automatically. I have go this working in Access, but I'm at a loss for how to do it with ASP.
I think that I need the script to execute after a change is made to the AssetNo field, but I have not been able to get it to work how I want. Code:
I am in the beginning phase of a project that will require automatic email reminders to be sent out. Has anyone had any experience or suggestions that might help me get started in the right direct. My project will use the following.
ASP/VBScript/SQL Server Express
Once a record has been added the Auto Email reminders will be sent every 24 hours for the first 3 days or until the receiving party has responded to a questionnaire.
i am auto numbering with sql in asp. my auto code worked but i am restructing my tables and i came across my auto numbered fields. my question is when you use auto number does it give an default field length in mssql and if it dose how do you specifi how long you want the field to be.
here is a sinpit of my code for a table using auto numbering.
sqlStr = "CREATE TABLE Consumer(Con_id INT IDENTITY (1,1) NOT NULL PRIMARY KEY, "&_ "Con_Fname VarChar(25), "&_
i want to call another asp page from my aspx web page in the form load of aspx page and populate certain values in the aspx page based on the results returned from asp page.. I have to pass certain parameters like username and password to the asp page and the asp page should be submitted automatically . How to implement the form submission of asp page automatically from the aspx page. Based on the seach results, certain fields in the aspx page should be populated.
I have no background knowledge in this area as yet.In ASP, is there a way to have a set of code to automatically redirect to another page in a given time period? eg: auto redirect to another page in 10 seconds.OR does it has to be done using javascripts or any other scripts?
I have a form which submits it's data to a hidden page(submit.asp).Submit.asp retrieves the data and submits to the db.Immediately once it has submitted data,it will then retrieve the auto generated id for the data just submitted.(hope this will work) Once I have retrievd the auto gen id, I want to then pass this id to *another page*. I don't want to then create the table on the submit.asp page as there is a huge amount of code there already-want to keep things clean.
How do I pass the value to another asp page?Is it something like response.redirect and how do I attach the id?
On my website I have users create an account. After they have created the account they have to log in. Is there a way that after the user has created the account it automatically logs them in?
Just a quick question, is it possible to automatically upload files to an FTP account via ASP? Ie if you have a link say, on an ASP page, saying Upload files now... and basically this would automatically upload a set of files which will be pre-set in the code... to an FTP account for which we know the address, username, password?
I have a few .asp pages in a framed website. I find that sometimes the .asp page reads from my cache instead of refreshing the Database fields when flipping between pages using a naviagation bar in a different frame. Anyone know a little line of code that I could place at the top of my pages that will maybe automatically refresh the page ONCE - when someone enters the page ?
