How to pick email from Sendor, subject and date

Help Studio
, ,
1

Subject :[WARNING - EXTERNAL] FW: !E-Past Due PO / Expedite Report_432654_SUNRICE, INC._

HI Guys, I need to filter the email with office 365

  1. Subject: 432654- bot has to pick email with this number only
  2. Sender: i.e for example: abc@sunrice.com
  3. Date: from today to last 7 days.
2

@ahmed4566,

Try this filter in Get Outlook mail messages.

"@SQL=""urn:schemas:httpmail:subject"" like '%432654%' AND [SenderEmailAddress] = 'abc@sunrice.com' AND [Received] >= '" + DateTime.Today.AddDays(-7).ToString("d") + " 00:00AM' AND [Received] < '"+ DateTime.Today.ToString("d") + " 00:00AM'"

image
image1393×290 22.3 KB

Thanks,
Ashok :slight_smile:

3

Thanks Ashok, I am using office 365 and please update the xpression on if condition and the subject will be the queue item key and for every transaction it will change so it will be saved as key

4

@ahmed4566 ,

My bad I missed O365.

Here is filter for O365.

Use Get Email List
image

Set Filter like this.

image
image806×564 17.5 KB

The key is a variable you can customize it as per your requirement.

Thanks,
Ashok :slight_smile:

5

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