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

rberke used Ask the Experts™
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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
After 4 months, it appears no one has an answer.  So, I  believe that my workaround is the only solution.  I will PAQ this question.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial