Read and Filter Outlook Emails with multiple SenderID

Help Studio
, ,
1

I need to read the outlook mails from two different senderID.
Using below condition
“[From]='”+in_Config(“mailAccount”).ToString+“‘OR’”+in_Config(“mailAccount2”).ToString+“'”

which is throwing Condition is not valid. Any leads help me

2

Hello @Kniranjan555 , try this:

([From] = ‘sender1@example.com’ OR [From] = ‘sender2@example.com’)

Cheers! :slight_smile:

3

image
image869×358 13 KB

This is condition still getting the same error

4

Hi @Kniranjan555

Try this syntax:

"[From]='" + in_Config("mailAccount").ToString + "' OR [From]='" + in_Config("mailAccount2").ToString + "'"

Hope it helps!!
Regards,

5

image
image872×285 12.3 KB

if i change to this i was getting [Option strict on disallows implicit conversions from ‘string’ to ‘long’ error

6

@Kniranjan555

Try this:

Regards,

7

Hi @Kniranjan555

try this its working

“([From] = ‘sender1@example.com’ OR [From] = ‘sender2@example.com’)”

you are placing “OR” you should check this once, you should use OR

image
image1200×699 34.5 KB

8

what is the error that you are getting?

9

Hi @Kniranjan555

In the Filter expression editor in Get Outlook Mail message activity, filtering of Sender Mail address is not working. I also felt with the same issue.
Output of the Get outlook mail message activity, Let call it as MailMessages.
In this case I have used one assign activity after the Get outlook Mail message this will filter the mails.

- Assign => MailMessages = MailMessages.Where(Function(x)x.Sender.Address.ToString.ToLower.Contains(“abc@gmail.com”) Or x.Sender.Address.ToString.ToLower.Contains("def@gmail.com")).ToList

Hope it helps!!

10

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