I would really appreciated if you could help me with this problem:
I need to filter in emails in outlook. However, outlook-inbox has differents folders.
Please look at the picture joined here
As you could notice, my inbox has differents folders levels.
i would like to set an activity in Studio which will go directly to one of the folders and taking its name (string) as an indicator to select the folder i will apply other instruction (filters)…
Any idea would be very appreciated , thanks
Use get outlook mail message in the folder give the foler path like
It has a filte rproperty where jet or dasl queries can be used
Hope this helps
Thank you very much for helping.
Just last question…please
i am trying to use “Get Outlook Mail Message” to filter 4 types of criterions ( if emails are unread, if they have an excel attachments (.csv ; xlsx; xls) and if they have red category).
as you see in the photo below, i 'm using options to set these filters:
but i can’t make the Expression editor to set a phrase code to make those 4 criterions to work…
I need a code-phrase (instruction) to filter: just excel files (types csv;xlsx;xls) AND Red category
Could you please help me with that?
Thanks in advance,
Please try this
"@SQL= ""urn:schemas:httpmail:hasattachment"" = true AND ( ""urn:schemas:httpmail:attachmentfilename"" LIKE '%.xlsx' OR ""urn:schemas:httpmail:attachmentfilename"" LIKE '%.xls' OR ""urn:schemas:httpmail:attachmentfilename"" LIKE '%.csv' ) AND ""urn:schemas:httpmail:category"" = 'red'"
Edited : True instead of 1
Thanks very much @Anil_G
Have a good weekend
Is it throwing error somewhere?
If yea remove the brackets
And move category statement with and condition before or conditions
i just tried remplacing true instead of 1 … and it works.
Thank you very much…
hope you are doing well .
I tested the code you sent to me in the “Get Outlook Mail Messages”
“@SQL= ““urn:schemas:httpmail:hasattachment”” = true AND ( ““urn:schemas:httpmail:attachmentfilename”” LIKE ‘%.xlsx’ OR ““urn:schemas:httpmail:attachmentfilename”” LIKE ‘%.xls’ OR ““urn:schemas:httpmail:attachmentfilename”” LIKE ‘%.csv’ ) AND ““urn:schemas:httpmail:category”” = ‘red’”
and i selected unread message and this is my outlook (there are just 4 unread message . what is more there is just 1 email with string ATCP
so that i should have just one “correct” in the ouput pannel as a result .
However, i notice that it went through all the emails…
REsults after running
Would you please help me how to find my mistake ?
First can you filter with unread may be there are old unread mails also…and can you try printing the subject of each mail so that we can check what those are…
And yes as atcp is only one you got correct log only once
Actually my checked twice my inbox and there is no other unread emails…
Thanks anyway for helping
Did you try printing the subject lines to know which emails are those?
Yes, and the subjects are those for the emails.
I think there is a bug …
so i am changing the strategy.
In the meantime: i am trying to use “For each email” activity instead of “For each”
to know if for each email could allow me to fix my filter problems
but it said i need a king of outlook account card…
Thanks for any suggestion of knowing what it means outlook account card…
First of all you can use the additional filters on the for each loop for most of your cases…
Is the same filter you are looking as condition in outlook card?