SQL query filter for get outlook mail message activity based on attachment name

I want to apply a filter in the Get outlook mail message activities filter property to read only the emails that have the attachment name having extension “.pdf” in it.
I want to use the SQL query method. example “@SQL=urn:schemas:httpmail:subject like ‘%Corporate Actions INVA%’”.

I tried using query “@SQL=urn:schemas:httpmail:attachmentfilename like ‘%.pdf%’”., but this is not working.

1 Like

any update ?

1 Like

Any solution?

By taking one mail message at a time, and iterating through the attachments of that mail message , and for each iteration checking if the attachment name in current iteration contains .pdf or not.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.