How to filter the outlook mails using the subject line?

Help Activities
, ,
1

Hi All,

I need to filter the mails in outlook based on the subject “Loan Management”.
I am using the expression “subject:Loan Management” but getting an error like this.
image
image

whats the error in this need support.

thanks in advance

2

Hi @naveen.s

"[subject]='Loan Management'"

Regards

3

Hi @naveen.s

try with the below query:

@SQL=urn:schemas:httpmail:subject LIKE '%Loan Management%'

Regards

4

@vrdabberu ,

there are 2 unread mails but after the reading the mails, its not going inside the for each loop.

5

by the way Loan Management - Asia Steel Factory ,
after - the values are dynamic, i.e "Loan management - "will be constant and remaining will be dynamic

6

Yeah this will work please check again @naveen.s


"@SQL=""urn:schemas:httpmail:subject"" like '%Loan Management%'"

Regards

7

@vrdabberu ,
thanks it worked can you please explain what the syntax represents, so I can know in detail.

8

Hi @naveen.s

Here is the detailed explanation for the query:

@SQL=: This indicates that the query is written in SQL-like syntax.
"urn:schemas:httpmail:subject": This is a namespace and schema identifier for the subject property of an email. The urn:schemas:httpmail namespace is used for defining various email properties in Microsoft Exchange and Outlook.
like '%Loan Management%': This is the condition being applied to the subject property. The like keyword is used to perform pattern matching. The % symbols are wildcard characters that represent any sequence of characters. Therefore, this condition checks if the subject of the email contains the phrase “Loan Management” anywhere within it.

Regards

1 Like
9

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