To Database And Email

I am creating a Change Management System where users log in and Log a request for a change to a problem that they are experiencing. The information is filled out in a HTML form and using ASP the information is sent to a MySQL database. This part is working fine. What I would like doing is if its possible, although I have seen it on other sites is when the user submits the form for the information to be sent to the database, i would also like an email generated with some of the information on it.

I am using a windows 2003 server and have used CDO in the past but don't realy know a lot about it. To be honest I don't realy know where to start with this problem, how to get the submit button to store the information and also generate an email. Any help would be greatly appreciated. I can send my code if it would be of help to anybody.

View Replies


ADVERTISEMENT

Email Validation Of Email Address Within An Access Database

Im running a simple mail system program which emails newsletters to a database list of 3000+ users.

The program loops through a database containing the emails and sends them out using ASPEmail.

My question is, is there some way i can validate each email address so that if there are invalid characters e.g. the space in "blah @blah.com"
it will skip the record and continue the loop.

At the moment i have a working program however, whenever the program comes across an invalid email address it stops at that record and prevents the program from emailing any further.

View Replies View Related

Email From Database

I wrote some lines of code on ASP but I am not sure about the logic...Because when I try to run the program it gives me error... I don’t know what is the wrong with the code… please help me... I am trying to read certain information from Access database for certain student and send the information to his email...
Example:
The student will enter his ID and click send then a message should be send to his email with his locker informatio

View Replies View Related

ASP Email And Database

I have an ASP page that inputs data into an Access database via form on page. The submit button on the page stores the data into the database without a problem. What I need to happen when the submit button is pressed is data stored into the database and an email sent to the administrator. Is this possible for me to do.

View Replies View Related

How To Mass Email From Database

I currently developing a Email marketing application using asp and aspemail for a client. They requested the application to be able to mass email to their client that is store in an access database. So how can i initiate the application email to all the email store in the database?

View Replies View Related

Send To Database And Email

Can ONE form with ONE submit button send the results to a database and also send the results via email?

View Replies View Related

Email Emails In The Database

Does anyone no or have a link to how i can send a Newsletter/Email to every Email address in my Database?

View Replies View Related

Email Updating A Database?

ive noticed loads of online apps that allow emails sent to a particular
address, to update a database i.e. ta-da.com - can this be achieved with
COMless scripting in asp?

View Replies View Related

Email Address From A Database

I trying to send an email using CDO Mail compontent with ASP.I would like to pull the email address from a database. I have created recordset, and I can get the first address to work, but I can not figure out a way to make it loop so it pulls all the email address from the database and sents the email to all of them.

View Replies View Related

Grab From Database And Send Email

I have another script where i pull all the information from the database and I want to send it to the person. What they do is they enter in their email, and if the email matches, than it will email them their login information.

How do you grab the info and than use that info and put it into an email to send?

Here is my code thus far for it: ....

View Replies View Related

Insert Database Records To Email

How to do i send database information to an html email using ASP?

View Replies View Related

Send Cdo Email With Database Data

i've got a database in ms access. using ASP (vbscript) and IIS. I can send text e-mails through ASP but i want to attach a file from the database to the e-mail when it is sent. can anyone give me any hints on how to get the data from access, attach it to the e-mail and send it on?

View Replies View Related

How To Use Href For Email Address Pulled From Database

I have the following code which displays email address from a database
However, I need to have the email address highlighted so that on clicking
the email box would open up with the email name filled in. Code:

View Replies View Related

Pull Informtion From Database And Send It On Email Id

I have been asked to try and write a program that basically pulls some info from a sql database and automatically emails it to an email address on a certain day of the week .
So if anyone can offer advice or if they know of any script or tutorials online.

View Replies View Related

Contact Form Email And Database Insertian

i made this asp script that should email and insert the data into a database but somehow i don't think I've done it right. Code:

View Replies View Related

Inserting Data To SQL Database And Sending Email At The Same Time?

I’m attempting to insert some basic information (name, address, details) to the sql database and send a notification email (at the same time).

Right now, I can insert the information to the DB after I click submit, but how can I also receive an email? Please give some ideas how to do it.

View Replies View Related

Blank Email Entry In Database (SMTP Badmail)

When a file is uploaded, notifications go out to Admins. Currently Admins have the ability to have 3 email addresses that the notification can be sent to.

Now lets say they only have 1 email address for a contact. When I run the code below, it cycles through to everyone that needs to be contacted and sends email to all 3 addresses.....BUT #2 & #3 are empty and then in my SMTP folder I receive a bunch of files in the badmail folder.

I need to correct this so that I can eliminate having to go and purge on a daily basis.

Now I am sure that there is a better way of doing this... I inherited this and am looking for some help with correcting this....

View Replies View Related

Syntax On Passing Variables From Email Form To Insert A Database...

I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.

View Replies View Related

Convert Html Page Or Database Shopping Basket To An Email

OK - I have a shopping basket with data in a database. Once the person
has successfully completed their order I want to be able to send them
an email with the products ordered roughly in the following format:

Product Price Quantity

prod1 £6.99 1
prod2 £5.99 2
Postage £0.50

Total whatever..I'm
lazy

Formatting would be a little different (just spacing out the prod
table a little more.

Any ideas or links to scripts that do this?. I've been looking for a
while now but have had no luck in finding a solution. I just want to
send a text email (and not html).

The other thing is that on the last page but one, this shopping basket
is displayed. Is there anyway I could capture the html data from that
page, store it in a session variable and then generate the email after
the order has been completed (so sort of like sending a mirror of that
page)? In that case having a HTML formatted email would be ok.

View Replies View Related

CDONTs - Problem Formatting An Email, From Form To Email

I am having a problem formatting an email message which comes from a form.

I am currently having difficulty with the <br> tag which I am using for line spaces within my email. I am getting an expected statement error message which is pointing to the line which is underlined below. I can't think what is causing this.

The code for my processing page is below:-

View Replies View Related

Generating Email Address And Textarea To Be Inlcluded On Email

1. I want users to type in their email address on a textfield, and after users press the "Submit" button. The info will automatically go to another person's email to receive a compliment, suggestion, etcetera.

2. Another is how to include the message written on a textarea of a form with the ASP code supplied below: Code:

View Replies View Related

Asp Email Verification Check Valid Email Thru Mx Record

how to write to check verification valid email thru nslookup or mx record or dns record. Is it possible to do that. Is there any tutorial from sitepoint, previously found it but i lost the link.

example to check assume test@domain.com is not a real email, abc@domain.com is real email
how do u check it.

View Replies View Related

Cdonts Email Script Won't Send Email

i used the following script but it won't send the email. any suggestions why?

<%
Dim TBdy
Dim MyCDO
CR = Chr(13)
Set MyCDO = Server.CreateObject("CDONTS.NewMail")
MyCDO.From = "person@something.org"
MyCDO.To = "allstar@aol.com"
MyCDO.Subject = "collegebound info"
TBdy = Request.Form("cb_name")
MyCDO.Body = TBdy
MyCDO.Importance = 1 (Normal)
MyCDO.Send
Set MyCDO = nothing

%>

View Replies View Related

Email Form - Verify Email Address

Just starting to play with scripts, and need a little guidance. I want to check to make sure that the email addresses users enter in a form are identical before it will allow them to submit. here's what i have:

the variable for the second email address is EmailFrom2

'validation
Dim validationOK
validationOK=true
If (Trim(EmailFrom)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("emailerror.htm?" & EmailFrom)
If (Trim(Name)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("nameerror.htm?")
If (Trim(CityState)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("citystateerror.htm?")
If (Trim(SchoolName)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("schoolnameerror.htm?")

View Replies View Related

ASP Email Form: Sends To Some Email Addresses But Not Others..

here is the script i use:

Set myMail=server.CreateObject("CDO.Message")
myMail.Subject="subject"
myMail.From="me"
myMail.To=request.form("email")
myMail.TextBody="hello"
myMail.Send
set myMail=nothing

this script sends emails to some addresses but not others--and its based on the email service it's sending to. for instance, hotmail email addresses get the email, but mail.com email addresses dont get the email. i have tried sending it to other email hosts, too, and still, some work, some don't. what is going on here?

View Replies View Related

Email Through CDONTS Using ISP Email Server

I am using CDONTS component to send email in ASP.

The code is some thing like this:

Dim Mail
Set Mail = Server.CreateObject("CDONTS.Newmail")
mail.From = "abc@hotmail.com"
mail.to = "xyz@hotmail.com"
mail.subject = "Test Email Subject"
mail.body = "This is Email body message"
mail.send

Now the question is that this code will use the Default Virtual SMTP Server in IIS, but I want to use my ISP's SMTP server. please tell me how to do this. I have used my ISP's email server in Outlook express and it is working fine. Please do not suggest to use "CDO" or "CDOSYS" to use for sending emails because I must have to use "CDONTS".

View Replies View Related

Database Limit - Microsoft JET Database Engine Error '80040e14'

I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.

<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn

'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof

'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")

'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>

I am getting this error;

Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

/guestbook/guest.asp, line 11

can anyone help me?

View Replies View Related

Microsoft JET Database Engine :: Cannot Update. Database Or Object Is Read-only

I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying

"Error Type:

Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"

can please anyone tell me why i am getting this error.

View Replies View Related

Remove Email Address/ Pseudo Email Address

has anyone got a function or subroutine which will remove blank out or remove email addresses.

i've wrote a function which will remove valid email addresses, it's pseudo addresses such as "blah @ blah.com" or "blah_at_blah_dot_com" or "blah_at_blah_._com"

the function is basically to stop users posting an email address in a message.

View Replies View Related

Database Connection String To MySQL-database On A Different Server

I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!


Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.

View Replies View Related

How Do I Export Data Fom Local Database To Server Database?

I'm current working on a project which need to upload local data to
live server database.

Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.

View Replies View Related

Microsoft JET Database Engine , Database Or Object Is Read-only

Error Type:

Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12

what is wrong! i checked the db and its not readonly.

View Replies View Related

Using Value From Database Updating The Database And Resuing The Value

i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved