Highlight Text in VBA HTML (1 Viewer)

stu_c · Jan 30, 2024

Hi All
I have VBA HTML code to work so it transfers everything from a form into an Email have managed to get bold to work but I ideally want some text to be highlighted in either red or yellow, I have tried
 and <BGcolor> but haveing some issues

Code:

sBody = sBody & "<B><mark>Highlight</mark></B>"

cheekybuddha · Jan 30, 2024

try:

Code:

sBody = sBody & "<B><span style='color:red;'>Highlight</span></B>"

Minty · Jan 30, 2024

You need to use the correct HTML formatting codes - something like

<body>"

stu_c · Jan 30, 2024

cheekybuddha said:
try:

Code:

sBody = sBody & "Highlight"

Hello,
That seems to only change the front colour not highlight / background colour

stu_c · Jan 30, 2024

The other option would to for it to open a Email template using

Code:

Set myOlApp = CreateObject("Outlook.Application")
Set MyItem = myOlApp.CreateItemFromTemplate("\\TemplateEmail.oft")
MyItem.Subject = "Status Report"

MyItem.display

and input into certain bookmark points but not entirely sure the code on how to do this?

arnelgp · Jan 30, 2024

Code:

Dim myOlApp, myItem
Set myOlApp = CreateObject("Outlook.Application")
Set MyItem = myOlApp.CreateItemFromTemplate("\\TemplateEmail.oft")
With myItem
    .Subject = "Status Report"
    .HTMLBody = Replace$(.HTMLBody, "Highlight", "<B><span style='color:red;'>Highlight</span></B>")
    .Display
End With

cheekybuddha · Jan 30, 2024

Did you try adjusting for yourself?

Code:

sBody = sBody & "<B><span style='background-color:red;'>Highlight</span></B>"

isladogs · Jan 30, 2024

Code:

<div><font color=red style="BACKGROUND-COLOR:#FFFF00">RED text with yellow highlighting</font></div>

cheekybuddha · Jan 30, 2024

Whilst the element will work in email HTML (note this is not Access rich-text), it's better to avoid teaching deprecated stuff IMHO.

isladogs · Jan 30, 2024

All the examples in that screenshot were created using Access rich text which is of course a subset of HTML.
Not all the features of rich text are included in the latest versions of HTML but you can guarantee that code will work in Access.
The converse isn't necessarily true.

Highlight Text in VBA HTML (1 Viewer)

stu_c

Registered User.

cheekybuddha

AWF VIP

Minty

AWF VIP

stu_c

Registered User.

stu_c

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

cheekybuddha

AWF VIP

isladogs

MVP / VIP

cheekybuddha

AWF VIP

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread