Get Outlook message Filter email

Help Studio
, ,
1

Dears,
I am using get Outlook Mail Message, I need to filter the email which is contain an excel sheet only… any idea how to do the same.

Thanks in advance

2

@mosa_sleeman,

You can use For each activity,

For each mail(must be type of system.net.mail.mailmessage) in MailMessage{
if mail.subject.contains(“abc”){
// do something
}Else{
// do something else
}
}

this way you can filter out emails

3

I need to filter if the email has an attachments with excel format

4

Hi,

hope this will help to resolve the issue

image
image1536×609 27.9 KB

6

Try using below expression in filter property

“[attachment]=’.xls’ OR [attachment]=’.xlsx’”

Refer here for more help : Chapter 11: Searching Outlook Data | Microsoft Learn

1 Like
7

Thanks For your replay,
it’s given me as below
image

8

Try removing the spaces

“[attachment]=’.xls’ OR [attachment]=’.xlsx’”

9

Well done, thanks

10

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