i want to have a user fill out a form, and have the results automatically emailed to the corresponding receiver also at the same time the results will store in a database, how to go about it?<BR><BR>thanx in advance
Check out this article:<BR><BR>Mailing Form Results<BR>http://www.4guysfromrolla.com/webtech/071599-1.shtml<BR><BR>This shows how to automatically send all of the results a user entered into a form via CDONTS.
Yes, you can do whatever you want with your variables after you got them from<BR>Request.Form("yourvar")or Request.QueryString("yourvar")<BR>depends on form METHOD you used.<BR>Then you can add them to db like that:<BR><BR><% set conn=server.createobject("adodb.Recordset")<BR>con n.ActiveConnection = "mydb"<BR>conn.Source = "table"<BR>conn.CursorType = 3 <BR>conn.LockType = 2 <BR>conn.Open<BR>conn.AddNew<BR>conn.Fields("yourv ar") = you<BR>conn. Update<BR>conn.close<BR>set conn=nothing%><BR>Then you can send email using CDO or any third part objects.<BR>For CDO:<BR><%<BR>Set oMailMessage = CreateObject("CDONTS.NewMail") <BR>' Send an email to firstname.lastname@example.org from email@example.com<BR>oMailMessage.from = <BR>oMailMessage.to = <BR>oMailMessage.subject =<BR>cont= yourvar<BR>cont= cont & "Thank you!"<BR>oMailMessage.Body = cont<BR>oMailMessage.Send()<BR>' Release the NewMail object<BR>Set oMailMessage = Nothing ' Release the object<BR>%><BR>