Filter email messages two conditions

Help Studio
, , ,
1

I try to filter and count received email in Outlook in a folder using Get Outlook Messages. The filter has two conditions (specific subject and body). I tried through “[Subject] LIKE ‘%Billing%’ AND [Body] LIKE ‘%Billing%’”
but returns an answer that the condition is not true. I also tried through “@SQL=urn:schemas:httpmail:subject LIKE ‘%Billing%’ AND @SQL=urn:schemas:httpmail:textdescription LIKE ‘%Billing%’”
but returns an answer
Get Outlook Mail Messages: Cannot parse condition. Error at “@SQL=urn:schemas:httpmail:textdescriptio…”.

Help please.

2

@plamenov.plamen

Please try like this

"@SQL=""urn:schemas:httpmail:subject"" like '%Billing%' and ""urn:schemas:httpmail:textdescription"" like '%Billing%'"

Cheers

4

return Get Outlook Mail Messages: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

5

@plamenov.plamen

I believe you copied exactly…I gave one inverted comma wrong…which is the last one…i just corrected…either correct in the code or copy the condition again from above

Cheers

6

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