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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.