Consulting

Results 1 to 2 of 2

Thread: change text colour in outlook message

  1. #1
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location

    change text colour in outlook message

    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

  2. #2
    Knowledge Base Approver
    The King of Overkill!
    VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •