VBA code to format email contents from excel.

Greetings,

Firstly I am a novice with VBA and macros so any help is greatly appreciated.
I have some code that will generate an email with the active sheet as an attachment. I also have the body of the email preset in the code. What I am trying to do is have a section of text in the body highlighted in yellow.

Here is the code I have:

Please Login or Register  to view this content.

The specific text I would like to have highlighted in the email is the "Estimated maintenance completion date: _____"

Thanks in advance for the help!

After some more searching I found what I needed to achieve the desired result. I wound up using HTML which was much easier as far as formatting goes.

Here is the mail section with the appropriate code:

Please Login or Register  to view this content.

Thanks