When form submits - Send an e-Mail: How? 1

DSect · Nov 19, 2001

I took over a website that was super-duper FrontPage server extension dependant.

In converting most of the forms to normal, non-wizarded .ASP, I ran into a small problem.

With this one form, a user submits info, presses submit and 2 things happen: 1. The info is inserted into a CSV file (ala FrontPage extensions) 2. An e-mail is dispatched to the person who works with the data.

Now I got the form/information insertion to database stuff with no problem, but I need to do something so that one of our staff will be notified when information is entered.

So - I would really like to make a small .ASP thing that takes information from one of my form fields and sends an e-mail to a staff member with the field info in the subject line.

- OR -

I would like to be able to popup a little message on the workers' PC's when a record is inserted.

I friccin' hate FrontPage Extensions, but the FPx auto-mailer on form submit is useful, I just need to replicate it WITHOUT using FPx's.

I've heard of CDONTS, but I have alot to learn about using it. In fact, I don't really know too much about .ASP, but I'm coming along well..

I am not looking for an exact answer, but maybe just point me in the right direction as to what methods / techniques to use or your opinions on how to do this. If you say that you'd use CDONTS, then I'll look into that, but you don't need to be real specific at this point.. I'm just digging for ideas.

Again - I have an .ASP form going to an SQL database and I want to have one of my co-workers receive an e-mail or some kind of notification when the form is submitted or the record is inserted.

Please help me get away from this FrontPage extension crap!!!!

Thanks in advance, as always!

*D*

Ragol1 · Nov 19, 2001

The quickest way I have found is ASPEmail just install a small programe on the server and add a few line sof code and your set.

BlastRadius · Nov 19, 2001

Heres a sample of CDONTS should help you get on your way.
check out sites like devguru.com, asp.com, and learnasp.com they will help you alot.
<%
' change these to reflect where form should go
fromName="Whoever"
fromAddress="somestudent@activeserverpages.com"
toName="Charles M. Carroll"
toAddress="cc@thebestweb.com"
subject="form send mail tutorial"
relay="mail.innerhost.com"
%>
<html><head>
<title>FormToBeMailed.asp</title>
</head><body bgcolor="#FFFFFF">
<form action="FormToBeMailedrespond.asp" method="GET">
Fill Out This Form For Us:<p>
First Name -> <input NAME="NameFirst" size="20"><br>
Last Name -> <input NAME="NameLast" size="20"><br>
Country -> <input NAME="Country" value="USA" size="20"><br>
State -> <input NAME="State" MaxLength="2" size="2"><br>
email copy to -> <input NAME="emailcopy" MaxLength="40" size="40"><br>

<input type="submit"><input type="reset">

<% ' do not touch these lines. Needed to send mail! %>
<input type="hidden" name="mail-from" value="<%=fromName%>">
<input type="hidden" name="mail-fromAddress" value="<%=fromAddress%>">
<input type="hidden" name="mail-to" value="<%=ToName%>">
<input type="hidden" name="mail-toaddress" value="<%=toaddress%>">
<input type="hidden" name="mail-subject" value="<%=subject%>">
<input type="hidden" name="mail-relay" value="<%=relay%>">
</form>
</body></html>

Here is the generic form responder that can be used with this or any form:

<html><head>
<title>serverobjectsmailrespond.asp</title>
</head><body bgcolor="#FFFFFF">
<%
' ASPMail(tm) from

http://www.serverobjects.com

' is not part of ASP per se,
' but a excellent third party component

my_from=request("mail-fromName&quot

my_fromAddress=request("mail-fromaddress&quot

my_to=request("mail-toName&quot

my_toAddress=request("mail-toaddress&quot

my_subject=request("mail-subject&quot

my_relay=request("mail-relay&quot

Set Mailer = Server.CreateObject("SMTPsvg.Mailer&quot

Mailer.RemoteHost = my_relay

Mailer.FromName = my_from
Mailer.FromAddress = my_fromAddress
Mailer.AddRecipient my_to, my_toaddress
Mailer.Subject = my_subject

for each whatever in request.querystring
If instr(whatever,"mail-&quot

=0 then
Mailer.BodyText = whatever & "=" & vbcrlf
Mailer.BodyText = request.querystring(whatever) & vbcrlf & vbcrlf
end if
next

for each whatever in request.form
If instr(whatever,"mail-&quot

=0 then
Mailer.BodyText = whatever & "=" & vbcrlf
Mailer.BodyText = request.form(whatever) & vbcrlf & vbcrlf
end if
next

my_emailcopy=request("emailcopy&quot

If my_emailcopy="" then
else
Mailer.AddRecipient "form filler",my_emailcopy
end if

If Mailer.SendMail then
Msg = "mail sent sucessfully!"
Else
Msg = "mail was not sent sucessfully<br>"
msg = msg & mailer.response & "<br>"
End If
response.write Msg
%>
</body></html>

DSect · Nov 20, 2001

Wow guys - Thanks, spec' BlastRadius.

Like I said, I am very green, but when pointed in the right direction I can probably get it. Thanks for pointing me in the right direction and giving me some excellent examples!!

Super appreciate it - Hopefully I'll be able to repay you or others later on.

Thanks again!
-D-

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

When form submits - Send an e-Mail: How? 1

DSect

Programmer

Ragol1

Programmer

BlastRadius

Programmer

DSect

Programmer

Similar threads

Part and Inventory Search

Sponsor