I’m trying to filter outlook email by Subject that starts with IPO example ‘IPO1234’ since there is single quote present in subject already, I’m quite not sure how to make this work.
I tried with
Also tried to use variable:
With same value inside. But didn’t work.
The first 3 letter of subject remain same i.e., IPO , so is it possible to filter email that stars with specific letters?
Please note that subject already contains ‘ ‘ (single quotation) marks in the prefix and suffix
Any help is appreciated.
Thank you In advance.
have a look here for filters (get outlook message)
Give a try:
"@SQL=""urn:schemas:httpmail:subject"" like '''IPO1234''%'"
we do escape the ’ with an additional ’ within the email filter expression
Thank you so much @ppr I’ll give a try and let you know.
Hi @ppr it did not work. Says cannot parse condition. Please help me how can i use variable with this.
What you shared is static.
Also very confused with Quotation marks.
please share with us on what you have implemented so far e.g. by some screenshots
Sure. I wanted to replace “IPO418586” with variable.
You mentioned that the search term has quotes ‘IPO418586’
The filterexpression needs to surround the searchterm with quotes
When quotes are part of searchterm then we escape it with an aditional quote
thats why following was mentioned above
did you already tried it?
Keep in mind also that % will wildcarding it