Start Free Trial

asked on

get the form response to an email

how do i get the form fill send to an email

i got it stored in the database, but i want those send request to email me

sql="INSERT INTO comentarios (nombre, email, producto, comentario)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("fname") & "',"
sql=sql & "'" & Request.Form("email") & "',"
sql=sql & "'" & Request.Form("consultorio") & "',"
sql=sql & "'" & Request.Form("message") & "')"

on error resume next
conn.Execute sql,recaffected
if err<>0 then
Response.Write("No update permissions!")
else
Response.Write("<h3>" & recaffected & " Nos pondremos en contacto con usted cuanto antes</h3>")
end if
conn.close

thats to the database, how to email me that info
regards

implement sending email .net

https://msdn.microsoft.com/en-us/library/system.net.mail.smtpclient(v=vs.110).aspx

or you can use SMTP option from DB

https://blogs.msdn.microsoft.com/suhde/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account/

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

is the correct answer