Bolding and Highlighting a String (1 Viewer)

DanielR · Mar 29, 2019

Using VBA in excel I want to place a string in an email:

With newEmail
.Body = "Approval Instruction are as follows:"
End With

I want 'Approval Instruction' to be highlighted and made bold.
How do I do this?

Gasman · Mar 29, 2019

Use .HTMLBody and string below?

Code:

"<b>Approval Instructions</b>" & " are as follows:"

DanielR · Mar 29, 2019

This does not work

DanielR · Mar 29, 2019

Sorry, It does work.
How do I specify a line break?
How do I highlight something?

Gasman · Mar 29, 2019

Look up HTML codes

https://www.w3schools.com/html/html_formatting.asp

Gasman · Mar 29, 2019

Here is something I use in one of my emails.

HTH

Code:

 ' Set up HTML tags
    strPad = "<tr><td>"
    strEndPad = "</td></tr>"
    strPadCol = "</td><td>"
    strBlankLine = "<tr></tr>"


            With objOutlookMsg
                .HTMLBody = .HTMLBody & strPad & str3rdPartyType & strPadCol & str3rdParty & strEndPad
                .HTMLBody = .HTMLBody & strPad & strDatetype & strPadCol & strDate & strEndPad
                .HTMLBody = .HTMLBody & strPad & "Method:" & strPadCol & strMethod & strEndPad
                .HTMLBody = .HTMLBody & strPad & "Reference:" & strPadCol & strRef & strEndPad
                .HTMLBody = .HTMLBody & strPad & "Amount:" & strPadCol & strAmount & strEndPad
                .HTMLBody = .HTMLBody & strPad & "Balance:" & strPadCol & strBalance & strEndPad
                ' Add any notes if they exist
                If Len(strNotes) > 0 Then
                    .HTMLBody = .HTMLBody & strPad & "Notes:" & strPadCol & strNotes & strEndPad
                End If
'                ' Add blank lines for next set
                .HTMLBody = .HTMLBody & strBlankLine & strBlankLine 
            End With

isladogs · Mar 29, 2019

Also have a look at the attached example which includes highlighting and other HTML tags

Bolding and Highlighting a String (1 Viewer)

DanielR

Registered User.

Gasman

Enthusiastic Amateur

DanielR

Registered User.

DanielR

Registered User.

Gasman

Enthusiastic Amateur

Gasman

Enthusiastic Amateur

isladogs

MVP / VIP

Attachments

Similar threads

Users who are viewing this thread