M
MHiemstra
I am using some code to automatically generate an email from a click of the
button and have been successful, however I am stumped on an issue.
Is there way to bold text in VBA that exists in a string so when it is sent
to an email to displays as bold. I am stuck in my html ways and am
realizing I don't know the tags or if tags are allowed in VBA.
Here is my code:
mess_body = "Help Id" & vbCrLf & Me.HELP_ID & vbCrLf & vbCrLf & "Module" & _
vbCrLf & Me.MODULE_ID.Column(1) & " - " & Me.MODULE_ID.Column(2)
& vbCrLf & vbCrLf & _
"Description" & vbCrLf & Me.CALL_DESCRIPTION & _
vbCrLf & vbCrLf & "Notes / Step by Step" & vbCrLf &
Me.RESOLUTION_NOTES
I want it to display as such
Help Id (Bold and underline)
333
Module (Bold and underline)
XXXX
Description (Bold and underline)
xcccxxx
Notes (Bold and underline)
xxxxx
button and have been successful, however I am stumped on an issue.
Is there way to bold text in VBA that exists in a string so when it is sent
to an email to displays as bold. I am stuck in my html ways and am
realizing I don't know the tags or if tags are allowed in VBA.
Here is my code:
mess_body = "Help Id" & vbCrLf & Me.HELP_ID & vbCrLf & vbCrLf & "Module" & _
vbCrLf & Me.MODULE_ID.Column(1) & " - " & Me.MODULE_ID.Column(2)
& vbCrLf & vbCrLf & _
"Description" & vbCrLf & Me.CALL_DESCRIPTION & _
vbCrLf & vbCrLf & "Notes / Step by Step" & vbCrLf &
Me.RESOLUTION_NOTES
I want it to display as such
Help Id (Bold and underline)
333
Module (Bold and underline)
XXXX
Description (Bold and underline)
xcccxxx
Notes (Bold and underline)
xxxxx