trishgyrl
01-31-2018, 03:33 PM
Hello all,
Looking at the picture I attached, I am trying to have all data entered in the form returned in the body of an email.
How can I get the caption of any checkboxes selected returned into the body of my email?
I used the code below but, it returned the caption on the frame instead of the caption of the active control in the frame.
I hope what I'm trying to ask that makes sense...
If Me.Frame1.ActiveControl.Caption = "Yes" And frameNewExis.Visible = True And frameNewExis.ActiveControl.Caption = "Existing" Then
strBody = "<BODY style=" & "font face=calibri" & "font size=11" & ">" & "<b><i>Please refer to the details of the request below:</i></b>" & _
"<br><br>" & _
"********************************************" & _
"<br><br>" & _
"<b>" & Me.lblDate & ": " & "</b>" & Me.txtDate.Value & _
"<br><br>" & _
"<b>" & Me.lblBusinessNeed & ": " & "</b>" & Me.txtBusinessNeed & _
"<br><br>" & _
"<b>" & Me.lblProduct & ": " & "</b>" & Me.txtProduct & _
"<br><br>" & _
"<b>" & Me.lblCopyFrom & ": " & "</b>" & Me.txtCopyFrom & _
"<br><br>" & _
"<b>" & Me.lblExtend & ": " & "</b>" & Me.txtExtend & _
"<br><br>" & _
"<b>" & Me.lblDeal & ": " & "</b>" & Me.frameNewExis.ActiveControl.Caption & _
"<br><br>" & _
"<b>" & Me.frameDealType.Caption & ": " & Me.frameDealType.ActiveControl.Caption & _
"<br><br>" & _
"<b>" & Me.Label1 & ": " & "</b>" & Me.TextBox1 & _
"<br><br>" & _
"********************************************" & "</BODY>"
End If
The part that says: "...Me.frameDealType.ActiveControl.Caption..." didn't turn out as I expected.
Also, if anyone knows a MUCH simpler way to convert inputted values in the form to the body of an email...please share! :)
Thanks in advance.
Looking at the picture I attached, I am trying to have all data entered in the form returned in the body of an email.
How can I get the caption of any checkboxes selected returned into the body of my email?
I used the code below but, it returned the caption on the frame instead of the caption of the active control in the frame.
I hope what I'm trying to ask that makes sense...
If Me.Frame1.ActiveControl.Caption = "Yes" And frameNewExis.Visible = True And frameNewExis.ActiveControl.Caption = "Existing" Then
strBody = "<BODY style=" & "font face=calibri" & "font size=11" & ">" & "<b><i>Please refer to the details of the request below:</i></b>" & _
"<br><br>" & _
"********************************************" & _
"<br><br>" & _
"<b>" & Me.lblDate & ": " & "</b>" & Me.txtDate.Value & _
"<br><br>" & _
"<b>" & Me.lblBusinessNeed & ": " & "</b>" & Me.txtBusinessNeed & _
"<br><br>" & _
"<b>" & Me.lblProduct & ": " & "</b>" & Me.txtProduct & _
"<br><br>" & _
"<b>" & Me.lblCopyFrom & ": " & "</b>" & Me.txtCopyFrom & _
"<br><br>" & _
"<b>" & Me.lblExtend & ": " & "</b>" & Me.txtExtend & _
"<br><br>" & _
"<b>" & Me.lblDeal & ": " & "</b>" & Me.frameNewExis.ActiveControl.Caption & _
"<br><br>" & _
"<b>" & Me.frameDealType.Caption & ": " & Me.frameDealType.ActiveControl.Caption & _
"<br><br>" & _
"<b>" & Me.Label1 & ": " & "</b>" & Me.TextBox1 & _
"<br><br>" & _
"********************************************" & "</BODY>"
End If
The part that says: "...Me.frameDealType.ActiveControl.Caption..." didn't turn out as I expected.
Also, if anyone knows a MUCH simpler way to convert inputted values in the form to the body of an email...please share! :)
Thanks in advance.