Bold Text is String...

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
 
M

MHiemstra

MHiemstra said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top