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.