Excel VBA Macro: Highlight Text and Change Font Color in HTML Email (Step-by-Step Tutorial)

preview_player
Показать описание
Excel VBA Macro: Highlight Text and Change Font Color in HTML Email (Step-by-Step Tutorial). In this video, we write code that allows us to change the font color and background/highlight color of text in an email sent through Outlook.

HTML colors for font and highlighting:

#ExcelVBA #ExcelMacro
Рекомендации по теме
Комментарии
Автор

Greg, your Excel VBA videos have been extremely helpful as I have been working to automate mass emails. I am extremely grateful as you have saved me hours of mindless copy and pasting!

nathanfinneran
Автор

OMG this is great and well explained. You have no idea how long I’ve been searching to learn how to highlight text and/or change font color to text in macro. Thank you so much!

ElizabethRivera-yuhh
Автор

you are awesome Greg. thanks for your ultimate videos !!

keep rocking

aashishmeshram
Автор

Greg... I appreciate your help.. This code works well in Access also. I have emails that I send out in Access and needed to be able to bold and color/emphasis words to get peoples attention. This WORKED great???? THANKS

commongroundindy
Автор

It was awesome, you saved my day.!
Thanks Greg.!

ranajsingh
Автор

Great video. Any chance you think you can paste your code into github or something?

BintonB
Автор

How would I write that I want to make a piece of text Araial Black, color #650A33 and size 48pts?

JoshuaThomas-rdxl
Автор

Can we also #Highlight the word China (I mean the value available in cell) ?

zahidimranx
Автор

how can you feed there a dynamic color code? p.e:
instead "<font color=#FF3060>" --> "<font color=#&colorcodefromacell>" ---> colorcodefromacell as string does not work :/

hansiman
Автор

Pls post the downloadable excel file it will be helpful

rajvenkat
join shbcf.ru