troubleshooting Question

Outlook 2010 custom view "conditional format" does not always turn email red.

Avatar of rberke
rberkeFlag for United States of America asked on
OutlookVBA
1 Comment1 Solution55 ViewsLast Modified:
I have a "conditional format" that turns outlook messages red when this condition is true:
From Contains Company
From Contains Division

emails do not turn red when the message is sent  from:  portal@CompanyHQ.org on behalf of Joe Doe <joe.doe@divisionOffice.org>

For some reason the conditional format treats that email as if it was sent just from "Joe Doe"

I may be forced to use an ugly workaround.  I could use application_newmailex vba to add a user defined field called "UdfFrom".

The vba program populates UdfFrom  using sendermailaddress (which would be portal@CompanyHQ.org in this case).  Then if anything  is in item.sentonbehalfofname it would use Outlook.PropertyAccessor.GetProperty(PR_TRANSPORT_MESSAGE_HEADERS)  to get the email headers, then scans for the From Address, and adds that to the senderemail address.
     
Does anybody have a better solution?
ASKER CERTIFIED SOLUTION
rberke
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros