Outlook 2016 attachment content search

Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#1
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-
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#3
Hi Diane. I see where that can be applied and it does appear to be a good (the only?) method to accomplish. I've seen many awesome solution samples from you via EMO newsletter. Do you have in your magic toolbox, a sample of a recent script that does similar, so I can analyze and have a starting point? I do basic VBA (ha ha pun) primarily for Excel, plus SQL scripting, but haven't done in Outlook other than view queries and custom fields. Thanks!
 

Similar threads

Top