Randy Redekopp
New Member
- Outlook version
- Outlook 2016 32 bit
- Email Account
- Office 365 Exchange
I use conditional formatting extensively to manage email alerts coming from the various devices and processes in my environment. I have turned on the QueryBuilder as some conditions require more advanced analysis but that won't help with this particular issue.
I am looking for a way to apply conditional formatting based on the contents of attachment(s). Most email alerts arrive with the message body populated so conditional formatting works great. However, some arrive as (HTML, TXT, or PDF) attachments (e.g. Alan Renouf's excellent vCheck script). If there are warning or error messages within the attachment(s), I want the email to be highlighted.
It appears from the research I have done that I cannot directly examine the contents of an attachment within a conditional formatting criteria. It appears that I have to use a macro to write the attachment(s) to disk, then search. If certain keywords were found it could then email that file back to me with a specific subject or category. I could then use conditional formatting to highlight as appropriate.
Most of the forum posts I found that applied to this scenario were quite old so I'm hoping there is a new, preferably native within Outlook solution. Thoughts?
Thanks
-Randy-
I am looking for a way to apply conditional formatting based on the contents of attachment(s). Most email alerts arrive with the message body populated so conditional formatting works great. However, some arrive as (HTML, TXT, or PDF) attachments (e.g. Alan Renouf's excellent vCheck script). If there are warning or error messages within the attachment(s), I want the email to be highlighted.
It appears from the research I have done that I cannot directly examine the contents of an attachment within a conditional formatting criteria. It appears that I have to use a macro to write the attachment(s) to disk, then search. If certain keywords were found it could then email that file back to me with a specific subject or category. I could then use conditional formatting to highlight as appropriate.
Most of the forum posts I found that applied to this scenario were quite old so I'm hoping there is a new, preferably native within Outlook solution. Thoughts?
Thanks
-Randy-