Consulting

Results 1 to 2 of 2

Thread: Colored font to send in email from VB

  1. #1
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location

    Colored font to send in email from VB

    Dear VBA gurus!

    I am looking at the possibility of sending an email from my VB excel spreadsheet that will color certain lines in different colors. I have the below code, where:

    warningString is a string that is given a value earlier. I would like that warningString to have a different color depending on parameters.

     
     
    Set objOutlookRecip = .Recipients.Add("me@myemail.com")
          objOutlookRecip.Type = olTo
          ' Set the Subject, Body, and Importance of the message.
          .Subject = "RISK ALERT"
          .Body = warningString
          .Importance = olImportanceHigh  'High importance
          ' Add attachments to the message.
            ' Set objOutlookAttach = .Attachments.Add(locationit)
          
          ' Resolve each Recipient's name.
    Is it possible? If so how?

    Thanks in advance!

  2. #2
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location
    Nobody knows?

Posting Permissions

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