VBA to BOLD portion of email in outlook

[kosherboy]

Hi,
In order to make a portion of an email bold i need to use html formatting but vba sets up the email very neatly and making the whole email in html format will make it look messy unless i starts configuring every word which can take a long time. Is there a way to just format part of the email in html and the rest via standard vba?

Please see script in below code marked in red and which i would like bolded.

Please Login or Register  to view this content.

[AlphaFrog]

You couldn't have an email that is both plain text formatted and HTML formatted.

Formatting text with HTML is not that difficult and you don't have to do it word by word.

Please Login or Register  to view this content.

[TMS]

Try:

Please Login or Register  to view this content.

[kosherboy]

Thanks guys.
And you're right, it's not that difficult!
One question, when i generate the email from excel the font comes out as calibri, when it's with html i get times new roman, how do i format as calibri?

[TMS]

You're welcome. Thanks for the rep.


http://www.w3schools.com/tags/tag_font.asp

Please Login or Register  to view this content.

[kosherboy]

Thank you TMS.
This is what the email generated:
Capture.PNG

Thanks for the link

[Norie]

kosherboy

In the code TMS posted you need to remove the space after the < and before the >.

[TMS]

Yes, apologies, Norie is correct. Unfortunately, the forum can be a bit snotty about posting HTML codes, particularly the "<" and ">" ... hence the extra spaces. I was expecting the editor to remove the extra spaces.

[kosherboy]

Thank you Norie.
And thanks again TMS.