Hello Forum,
I would really appreciated if you could help me with this problem.
I need to filter outlook emails following 4 criterion:
- unread emails
- email having a red category
- emails having an excel attachements (xls, csv and xlsx)
- emails having differents string patterns in its name attachments or the email subject
to comply with it i used a “get outlook mail message” activity. Moreover, in the properties pannel of this activity i selected ( following options)
- OnlyUnreadMessage to comply with point 1
- Filter option to comply with point 2: “[Categories] = ‘Red Category’'”
- for point 3: i used a “for each” activity after the “Get Outlook mail message” and a else if activity inside the “for each” with this condition:
mail.Attachments.Any(function(x) x.Name.ToLower.Contains(“.xlsx” )) or mail.Attachments.Any(function(x) x.Name.ToLower.Contains(“.xls” )) or mail.Attachments.Any(function(x) x.Name.ToLower.Contains(“.csv” ))
Please look at this picture for details
a. - Would you please help me to find how to comply with point 4 (how to catch and verify if attachments’ names follow string patters on email attachment or email subject)
b.- if you have any suggestion on how my program would be constructed in a more efficient way or a different form to comply with the criterion to filter , please dont hesitage to give me your opinions, Thanks
Ricardo