PDA

View Full Version : change text colour in outlook message



gibbo1715
02-02-2006, 05:12 AM
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

mvidas
02-02-2006, 06:34 AM
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 .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>"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