When a user submits a contact form, it is a good idea to insert a copy of that email into a database for future reference. Here is how you can insert your form data to a simple MS Access database.
The first thing you need to do is create a form page called /Form.asp with the code below:
<form name="YourFormName" method="Post" action="confirmation.asp">
Email: <input type="text" name="Email" size="50"><br>
Name: <input type="text" name="Name" size="50"><br>
Comments: <textarea name="Comments"></textarea><br>
<input type="submit" name="Submit" value="Submit Form">
</form>
Next, we create a confirmation page called /Confirmation.asp and enter the code as seen below:
<%
' First open your database connection
%>
<!--#INCLUDE VIRTUAL="/includes/connection.asp" -->
<%
DIM objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "YOUR table name HERE", objConn, , adLockOptimistic, adCmdTable
' Add a new record to the database containing your form data
objRS.AddNew
objRS("Email") = Request.Form("Email")
objRS("Name") = Request.Form("Name")
objRS("Comments") = Request.Form("Comments")
objRS.Update
' Close your database connection
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
' You could also include an email script here to send your form via email
%>
<p>
<%
' Display a confirmation message
DIM strName
strName = Request.Form("Name")
Response.Write strName
%>,</p>
<p>Thank you for emailing me.</>
Now you have a contact form that is recorded in your database that you can refer back to in the future. This is a great way to follow up with customers and track how many people are using your website from year to year.
