Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.
Nou pe simpatie:
Kitana pe Simpatie.ro
Femeie
25 ani
Bucuresti
cauta Barbat
25 - 48 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Highlight Text in Email with Background Color [VBA] Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
Mrrrr
AdMiN

Inregistrat: acum 17 ani
Postari: 2186
You will need to make a HTMLBody for this to work, of course.

Wrap the following tags around your text:
<span style='background:yellow;mso-highlight:yellow'>your text here</span>

Result would be some text highlighted with yellow, the way you can do it in Word or with a text marker / highlighter on paper.

Example (piece of code):

            tmpBody = tmpBody & "<p></p>" & _
                        "<b>Check " & _
                                           "BLA BLA BLA" & _
                                                                  "</b> for: <b> <span style='background:yellow;mso-highlight:yellow'>" & _
                                Cells(cell.Row, "B").Value & "</span></b>, with: " & _
                                Cells(cell.Row, "D").Value & ", when: <b>" & _
                                Cells(cell.Row, "F").Value & "</b>, in: <b><font color=red>" & _
                                Cells(cell.Row, "V").Value & " days" & _
                                Cells(cell.Row, "X").Value & "</b></font> <u>Initial state was:</u> <b>" & _
                                Cells(cell.Row, "I").Value & "</b>" & _


_______________________________________


pus acum 5 ani
   
TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 739
The single quotations ' (underlined below) in the following line are not necessarily required:
<span style='background:yellow;mso-highlight:yellow'>

It can be without them, like this:
<span style=background:yellow;mso-highlight:yellow>


pus acum 3 ani
   
Pagini: 1  

Mergi la