Do I have to manually enter info from an asp.net 4 email into an MS Database?
I have a form email, asp.net 4.0 / VB / Visual Studio, and I want it to go automatically into a Microsoft Access DB without any effort from me.  Is this possible?  I'm not a programmer, but here's the form e-mail:

>     <script runat="server">
>         Protected Sub SubmitForm_Click(ByVal sender As Object, ByVal e As System.EventArgs)
>             If Not Page.IsValid Then Exit Sub
> 
>             Dim SendResultsTo As String = "me@domain.com"
>             Dim smtpMailServer As String = "smtp.domain.com"
>             Dim smtpUsername As String = "me@domain.com"
>             Dim smtpPassword As String = "******"
>             Dim MailSubject As String = "Form Results"
> 
>             Try
>                 Dim txtQ As TextBox = Me.FormContent.FindControl("TextBoxQ")
>                 If txtQ IsNot Nothing Then
>                     Dim ans As String = ViewState("hf1")
>                     If ans.ToLower <> txtQ.Text.ToLower Or ans.ToUpper <> txtQ.Text.ToUpper Then
>                         Me.YourForm.ActiveViewIndex = 3
>                         Exit Sub
>                     End If
>                 End If
> 
>                 Dim FromEmail As String = SendResultsTo
>                 Dim msgBody As StringBuilder = New StringBuilder()
>                 Dim sendCC As Boolean = False
> 
>             
>                 For Each c As Control In Me.FormContent.Controls
>                     Select Case c.GetType.ToString
>                         Case "System.Web.UI.WebControls.TextBox"
>                             Dim txt As TextBox = CType(c, TextBox)
>                             If txt.ID.ToLower <> "textboxq" Then
>                                 msgBody.Append(txt.ID & ": " & txt.Text & vbCrLf & vbCrLf)
>                             End If
>                             If txt.ID.ToLower = "email" Then
>                                 FromEmail = txt.Text
>                             End If
>                             If txt.ID.ToLower = "subject" Then
>                                 MailSubject = txt.Text
>                             End If
>                         Case "System.Web.UI.WebControls.CheckBox"
>                             Dim chk As CheckBox = CType(c, CheckBox)
>                             If chk.ID.ToLower = "checkboxcc" Then
>                                 If chk.Checked Then sendCC = True
>                             Else
>                                 msgBody.Append(chk.ID & ": " & chk.Checked & vbCrLf & vbCrLf)
>                             End If
>                             
>                         Case "System.Web.UI.WebControls.RadioButton"
>                             Dim rad As RadioButton = CType(c, RadioButton)
>                             msgBody.Append(rad.ID & ": " & rad.Checked & vbCrLf & vbCrLf)
>                         Case "System.Web.UI.WebControls.DropDownList"
>                             Dim ddl As DropDownList = CType(c, DropDownList)
>                             msgBody.Append(ddl.ID & ": " & ddl.SelectedValue & vbCrLf & vbCrLf)
>                     End Select
>                 Next
>                 msgBody.AppendLine()
>                 
>                 msgBody.Append("Browser: " & Request.UserAgent & vbCrLf & vbCrLf)
>                 msgBody.Append("IP Address: " & Request.UserHostAddress & vbCrLf & vbCrLf)
>                 msgBody.Append("Server Date & Time: " & DateTime.Now & vbCrLf & vbCrLf)
> 
>                 Dim myMessage As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage()
>                 myMessage.To.Add(SendResultsTo)
>                 myMessage.From = New System.Net.Mail.MailAddress(FromEmail)
>                 myMessage.Subject = MailSubject
>                 myMessage.Body = msgBody.ToString
>                 myMessage.IsBodyHtml = False
>                 If sendCC Then myMessage.CC.Add(FromEmail)
> 
>                 
>                 Dim basicAuthenticationInfo As New System.Net.NetworkCredential(smtpUsername, smtpPassword)
>                 Dim MailObj As New System.Net.Mail.SmtpClient(smtpMailServer)
>                 MailObj.Credentials = basicAuthenticationInfo
>                 MailObj.Send(myMessage)
> 
>                 Me.YourForm.ActiveViewIndex = 1
>             Catch
>                 Me.YourForm.ActiveViewIndex = 2
>             End Try
>         End Sub
> 
>         Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
>             If Not Page.IsPostBack Then
>                 Dim lbl As Label = Me.FormContent.FindControl("labelq")
>                 If lbl IsNot Nothing Then
>                     Dim rq(3) As String
>                     rq(0) = "Is fire hot or cold?"
>                     rq(1) = "Is ice hot or cold?"
>                     rq(2) = "Is water wet or dry?"
> 
>                     Dim ra(3) As String
>                     ra(0) = "hot"
>                     ra(1) = "cold"
>                     ra(2) = "wet"
>                     
>                     Dim rnd As New Random
>                     Dim rn As Integer = rnd.Next(0, 3)
>                     lbl.Text = rq(rn)
>                     ViewState("hf1") = ra(rn)
>                 End If
>             End If
>         End Sub
>     </script> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server"> <h1>CONTACT HEALTH
> NUTTS AND WORK FROM THE COMFORT OF YOUR OWN HOME!</h1><br /><br />
>         <asp:MultiView ID="YourForm" runat="server" ActiveViewIndex="0">
>             <asp:View ID="FormContent" runat="server">
>                         <label for="Email">
>                     Enter your Email Address:<br />
>                     <asp:TextBox ID="Email" runat="server" Columns="35">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="Email"
>                     Display="Dynamic" ErrorMessage="Please enter your email address." SetFocusOnError="True"
>                     CssClass="ValidateMessage" ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
> ControlToValidate="Email"
>                     ErrorMessage="Please enter a valid email address." SetFocusOnError="True"
> ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
>                     CssClass="ValidateMessage" ForeColor="">* Please enter a valid email address.</asp:RegularExpressionValidator>
>                 <br />
>                 <br />
>                         <label for="Subject">
>                     Subject:<br />
>                     <asp:TextBox ID="Subject" runat="server" Columns="50">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
> ControlToValidate="Subject"
>                     ErrorMessage="Please enter a subject." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="Message">
>                     Please type your message below:
>                     <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
> ControlToValidate="Message"
>                         ErrorMessage="Please enter a message" SetFocusOnError="True" CssClass="ValidateMessage"
>                         ForeColor="">* Required</asp:RequiredFieldValidator>
>                     <br />
>                     <asp:TextBox ID="Message" runat="server" TextMode="MultiLine" Columns="55" Rows="10">
>                     </asp:TextBox>
>                 </label>
>                 <br />
>                 <br />
>                         <label for="First_Name">
>                     First Name:<br />
>                     <asp:TextBox ID="First_Name" runat="server" Columns="35"></asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
> ControlToValidate="First_Name"
>                     ErrorMessage="Please enter your first name." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="Last_Name">
>                     Last Name:<br />
>                     <asp:TextBox ID="Last_Name" runat="server" Columns="35">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
> ControlToValidate="Last_Name"
>                     ErrorMessage="Please enter your last name." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="Phone">
>                     Phone Number:<br />
>                     <asp:TextBox ID="Phone" runat="server" Columns="40">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="Phone"
>                     Display="Dynamic" ErrorMessage="Please enter your phone number." SetFocusOnError="True"
>                     CssClass="ValidateMessage" ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"
> ControlToValidate="Phone"
>                     ErrorMessage="Please enter a valid U.S. phone number (including dashes)." SetFocusOnError="True"
>                     ValidationExpression="((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}" CssClass="ValidateMessage"
>                     ForeColor="">* Please enter a valid U.S. phone number (including dashes).</asp:RegularExpressionValidator>
>                 <br />
>                 <br />
>                         <label for="City">
>                     City:<br />
>                     <asp:TextBox ID="City" runat="server" Columns="60">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="City"
>                     ErrorMessage="Please enter your city." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="State">
>                     State/Province:<br />
>                     <asp:TextBox ID="State" runat="server" Columns="60">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="State"
>                     ErrorMessage="Please enter your state/province." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="True"
>                     ShowSummary="False" CssClass="ValidateMessage" ForeColor="" />
>                 <br />
>                 <br />
>                 <asp:CheckBox ID="CheckBoxCC" runat="server" Text="Send me a carbon copy of this email." />
>                 <br />
>                 <br />
>                 <asp:Button ID="SubmitForm" runat="server" OnClick="SubmitForm_Click" Text="Submit Form" />
>                 <br />
>             </asp:View>
>             <asp:View ID="FormConfirmationMessage" runat="server">
>                 Your message has been sent. Thank you for contacting us.<br />
>             </asp:View>
>             <asp:View ID="FormErrorMessage" runat="server">
>                 Due to technical difficulty, your message may NOT have been sent.
>             </asp:View>
>             <asp:View ID="FormSpamMessage" runat="server">
>                 You did not correctly answer the anti-spam question. Please go back and try again.</asp:View>
>         </asp:MultiView>

When someone fills out the form, I get an e-mail like this:


> Email: rmajeski@yahoo.com
> 
> Subject: I need A Job
> 
> Message: Me wants job today okay? Thank you for J.O.B
> 
> First_Name: Rich
> 
> Last_Name: Majeski
> 
> Phone: xxx-xxx-xxxx
> 
> City: Hockeytown
> 
> State: Michigan
> 
> 
> Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101
> Firefox/12.0
> 
> IP Address: 108.224.49.14
> 
> Server Date & Time: 5/15/2012 6:03:33 AM

How can I make this go into a Microsoft Access DB automatically, without me having to do it manually?  Any guidance would be truly appreciated!  Thanks!
Do I have to manually enter info from an asp.net 4 email into an MS Database?
===

I have a form email, asp.net 4.0 / VB / Visual Studio, and I want it to go automatically into a Microsoft Access DB without any effort from me.  Is this possible?  I'm not a programmer, but here's the form e-mail:

>     <script runat="server">
>         Protected Sub SubmitForm_Click(ByVal sender As Object, ByVal e As System.EventArgs)
>             If Not Page.IsValid Then Exit Sub
> 
>             Dim SendResultsTo As String = "me@domain.com"
>             Dim smtpMailServer As String = "smtp.domain.com"
>             Dim smtpUsername As String = "me@domain.com"
>             Dim smtpPassword As String = "******"
>             Dim MailSubject As String = "Form Results"
> 
>             Try
>                 Dim txtQ As TextBox = Me.FormContent.FindControl("TextBoxQ")
>                 If txtQ IsNot Nothing Then
>                     Dim ans As String = ViewState("hf1")
>                     If ans.ToLower <> txtQ.Text.ToLower Or ans.ToUpper <> txtQ.Text.ToUpper Then
>                         Me.YourForm.ActiveViewIndex = 3
>                         Exit Sub
>                     End If
>                 End If
> 
>                 Dim FromEmail As String = SendResultsTo
>                 Dim msgBody As StringBuilder = New StringBuilder()
>                 Dim sendCC As Boolean = False
> 
>             
>                 For Each c As Control In Me.FormContent.Controls
>                     Select Case c.GetType.ToString
>                         Case "System.Web.UI.WebControls.TextBox"
>                             Dim txt As TextBox = CType(c, TextBox)
>                             If txt.ID.ToLower <> "textboxq" Then
>                                 msgBody.Append(txt.ID & ": " & txt.Text & vbCrLf & vbCrLf)
>                             End If
>                             If txt.ID.ToLower = "email" Then
>                                 FromEmail = txt.Text
>                             End If
>                             If txt.ID.ToLower = "subject" Then
>                                 MailSubject = txt.Text
>                             End If
>                         Case "System.Web.UI.WebControls.CheckBox"
>                             Dim chk As CheckBox = CType(c, CheckBox)
>                             If chk.ID.ToLower = "checkboxcc" Then
>                                 If chk.Checked Then sendCC = True
>                             Else
>                                 msgBody.Append(chk.ID & ": " & chk.Checked & vbCrLf & vbCrLf)
>                             End If
>                             
>                         Case "System.Web.UI.WebControls.RadioButton"
>                             Dim rad As RadioButton = CType(c, RadioButton)
>                             msgBody.Append(rad.ID & ": " & rad.Checked & vbCrLf & vbCrLf)
>                         Case "System.Web.UI.WebControls.DropDownList"
>                             Dim ddl As DropDownList = CType(c, DropDownList)
>                             msgBody.Append(ddl.ID & ": " & ddl.SelectedValue & vbCrLf & vbCrLf)
>                     End Select
>                 Next
>                 msgBody.AppendLine()
>                 
>                 msgBody.Append("Browser: " & Request.UserAgent & vbCrLf & vbCrLf)
>                 msgBody.Append("IP Address: " & Request.UserHostAddress & vbCrLf & vbCrLf)
>                 msgBody.Append("Server Date & Time: " & DateTime.Now & vbCrLf & vbCrLf)
> 
>                 Dim myMessage As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage()
>                 myMessage.To.Add(SendResultsTo)
>                 myMessage.From = New System.Net.Mail.MailAddress(FromEmail)
>                 myMessage.Subject = MailSubject
>                 myMessage.Body = msgBody.ToString
>                 myMessage.IsBodyHtml = False
>                 If sendCC Then myMessage.CC.Add(FromEmail)
> 
>                 
>                 Dim basicAuthenticationInfo As New System.Net.NetworkCredential(smtpUsername, smtpPassword)
>                 Dim MailObj As New System.Net.Mail.SmtpClient(smtpMailServer)
>                 MailObj.Credentials = basicAuthenticationInfo
>                 MailObj.Send(myMessage)
> 
>                 Me.YourForm.ActiveViewIndex = 1
>             Catch
>                 Me.YourForm.ActiveViewIndex = 2
>             End Try
>         End Sub
> 
>         Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
>             If Not Page.IsPostBack Then
>                 Dim lbl As Label = Me.FormContent.FindControl("labelq")
>                 If lbl IsNot Nothing Then
>                     Dim rq(3) As String
>                     rq(0) = "Is fire hot or cold?"
>                     rq(1) = "Is ice hot or cold?"
>                     rq(2) = "Is water wet or dry?"
> 
>                     Dim ra(3) As String
>                     ra(0) = "hot"
>                     ra(1) = "cold"
>                     ra(2) = "wet"
>                     
>                     Dim rnd As New Random
>                     Dim rn As Integer = rnd.Next(0, 3)
>                     lbl.Text = rq(rn)
>                     ViewState("hf1") = ra(rn)
>                 End If
>             End If
>         End Sub
>     </script> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server"> <h1>CONTACT HEALTH
> NUTTS AND WORK FROM THE COMFORT OF YOUR OWN HOME!</h1><br /><br />
>         <asp:MultiView ID="YourForm" runat="server" ActiveViewIndex="0">
>             <asp:View ID="FormContent" runat="server">
>                         <label for="Email">
>                     Enter your Email Address:<br />
>                     <asp:TextBox ID="Email" runat="server" Columns="35">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="Email"
>                     Display="Dynamic" ErrorMessage="Please enter your email address." SetFocusOnError="True"
>                     CssClass="ValidateMessage" ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
> ControlToValidate="Email"
>                     ErrorMessage="Please enter a valid email address." SetFocusOnError="True"
> ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
>                     CssClass="ValidateMessage" ForeColor="">* Please enter a valid email address.</asp:RegularExpressionValidator>
>                 <br />
>                 <br />
>                         <label for="Subject">
>                     Subject:<br />
>                     <asp:TextBox ID="Subject" runat="server" Columns="50">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
> ControlToValidate="Subject"
>                     ErrorMessage="Please enter a subject." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="Message">
>                     Please type your message below:
>                     <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
> ControlToValidate="Message"
>                         ErrorMessage="Please enter a message" SetFocusOnError="True" CssClass="ValidateMessage"
>                         ForeColor="">* Required</asp:RequiredFieldValidator>
>                     <br />
>                     <asp:TextBox ID="Message" runat="server" TextMode="MultiLine" Columns="55" Rows="10">
>                     </asp:TextBox>
>                 </label>
>                 <br />
>                 <br />
>                         <label for="First_Name">
>                     First Name:<br />
>                     <asp:TextBox ID="First_Name" runat="server" Columns="35"></asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
> ControlToValidate="First_Name"
>                     ErrorMessage="Please enter your first name." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="Last_Name">
>                     Last Name:<br />
>                     <asp:TextBox ID="Last_Name" runat="server" Columns="35">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
> ControlToValidate="Last_Name"
>                     ErrorMessage="Please enter your last name." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="Phone">
>                     Phone Number:<br />
>                     <asp:TextBox ID="Phone" runat="server" Columns="40">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="Phone"
>                     Display="Dynamic" ErrorMessage="Please enter your phone number." SetFocusOnError="True"
>                     CssClass="ValidateMessage" ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"
> ControlToValidate="Phone"
>                     ErrorMessage="Please enter a valid U.S. phone number (including dashes)." SetFocusOnError="True"
>                     ValidationExpression="((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}" CssClass="ValidateMessage"
>                     ForeColor="">* Please enter a valid U.S. phone number (including dashes).</asp:RegularExpressionValidator>
>                 <br />
>                 <br />
>                         <label for="City">
>                     City:<br />
>                     <asp:TextBox ID="City" runat="server" Columns="60">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="City"
>                     ErrorMessage="Please enter your city." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <label for="State">
>                     State/Province:<br />
>                     <asp:TextBox ID="State" runat="server" Columns="60">
>                     </asp:TextBox>
>                 </label>
>                 <asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="State"
>                     ErrorMessage="Please enter your state/province." SetFocusOnError="True" CssClass="ValidateMessage"
>                     ForeColor="">* Required</asp:RequiredFieldValidator>
>                 <br />
>                 <br />
>                         <asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="True"
>                     ShowSummary="False" CssClass="ValidateMessage" ForeColor="" />
>                 <br />
>                 <br />
>                 <asp:CheckBox ID="CheckBoxCC" runat="server" Text="Send me a carbon copy of this email." />
>                 <br />
>                 <br />
>                 <asp:Button ID="SubmitForm" runat="server" OnClick="SubmitForm_Click" Text="Submit Form" />
>                 <br />
>             </asp:View>
>             <asp:View ID="FormConfirmationMessage" runat="server">
>                 Your message has been sent. Thank you for contacting us.<br />
>             </asp:View>
>             <asp:View ID="FormErrorMessage" runat="server">
>                 Due to technical difficulty, your message may NOT have been sent.
>             </asp:View>
>             <asp:View ID="FormSpamMessage" runat="server">
>                 You did not correctly answer the anti-spam question. Please go back and try again.</asp:View>
>         </asp:MultiView>

When someone fills out the form, I get an e-mail like this:


> Email: rmajeski@yahoo.com
> 
> Subject: I need A Job
> 
> Message: Me wants job today okay? Thank you for J.O.B
> 
> First_Name: Rich
> 
> Last_Name: Majeski
> 
> Phone: xxx-xxx-xxxx
> 
> City: Hockeytown
> 
> State: Michigan
> 
> 
> Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101
> Firefox/12.0
> 
> IP Address: 108.224.49.14
> 
> Server Date & Time: 5/15/2012 6:03:33 AM

How can I make this go into a Microsoft Access DB automatically, without me having to do it manually?  Any guidance would be truly appreciated!  Thanks!