% If Request.Form("Submit") = "Submit" Then set conn = server.CreateObject ("ADODB.Connection") conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("Database\menzspa.mdb") set rs = server.CreateObject ("ADODB.Recordset") rs.open "Select * From Enquiry" , conn, 2, 2 rs.AddNew rs("Name") = request.form("txtName") rs("Email") = request.form("txtEmail") rs("Mobile") = request.form("txtMobile") rs("Message") = request.form("txtMessage") rs.Update rs.Close set rs = nothing HTML = "" & vbCrLf HTML = HTML & "" & vbCrLf HTML = HTML & "
" & vbCrLf HTML = HTML & "" & vbCrLf HTML = HTML & "Enquiry | ||
| Name | " HTML = HTML & ": | " HTML = HTML & "" & request.form("txtName") & " |
| : | " HTML = HTML & "" & request.form("txtEmail") & " | |
| Contact | " HTML = HTML & ": | " HTML = HTML & "" & request.form("txtMobile") & " |
| Message | " HTML = HTML & ": | " HTML = HTML & "" & request.form("txtMessage") & " |
| Date | " HTML = HTML & ": | " HTML = HTML & "" & Date() & " |
| Time | " HTML = HTML & ": | " HTML = HTML & "" & Time() & " |