Change font color of a certain string

[needhelptdot]

I'm trying to write a code that will extract information from an excel table and copy it into an email in outlook. It's basically a checklist and if its checked of, the excel sheet will say '(check)' in the column. The outlook email should have the label name and if that label has been checked from the userform, it should say (check) beside it in the email. Example:

Excel...

Column 1 Column 2 Column 3
1. Copy file (check)
2. delete file

Outlook Email...

(check) 1. Copy file
2. Delete file

So when the email says (check)...I was wondering if just that string could be changed to RED font. Any ideas?

 

[Norie]

If this is for the body of an email you could do it but you would need to use HTML.

You would also need to alter any code you have for the email to use HTMLBody.

 

[needhelptdot]

Yeh this is for the body, and I tried using .HTMLbody = w/e but then that means I have to recode my entire strBody to suit the formatting. Any other ways I could do this?

 

[Norie]

Not that I know of and I'm not sure you'll need to recode everything.

You just need to add the appropriate HTML tags and that should be straightforward for what you want to do.