frubeng
02-17-2010, 11:10 AM
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!
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!