All
I am using excel to generate an email message in outlook, is there a way to change the colour of one line of text to red?
cheers
Gibbo
All
I am using excel to generate an email message in outlook, is there a way to change the colour of one line of text to red?
cheers
Gibbo
Hey Gibbo,
Depends on how you're using excel to send the email. If you're just using .sendmail (or whatever the built-in method is), then I dont think theres a way, however if you're using the outlook object to do this, the mailitem has an .htmlbody property you could use. You'd just have to do something like[vba] .HTMLBody = "Normal black text<br>Lots of normal black text<br><font color=red>" & _
"A line of red text!</font><br>Back to good old black.<br>"[/vba]Also, as an FYI, if you have any questions about using outlook and excel together, take a look at http://www.rondebruin.nl/sendmail.htm its a great site for sending mail from excel.
Matt
Last edited by mvidas; 02-02-2006 at 06:36 AM. Reason: formatted vba code