In Outlook mail message how to filter with subject and today mail

Suggest a expression to filter in Outlook mail message by subject and today date.
Thanks in advance :slightly_smiling_face:

1 Like

@Gopi_Krishna1,

Use this as filter :

"[Subject] = 'Desire Subject String here' AND [Received] >= '" + DateTime.Today.ToString("d") + " 00:00AM'"

Thanks,
Ashok :slight_smile:

I’m passing subject name in in_config() argument please modify for that

@Gopi_Krishna1,

Put this in Config file:

[Subject] = 'Desire Subject String here' AND [Received] >= '#Today# 00:00AM'

Use in Workflow like this by replacing placeholder with actual today’s day.

strFilterValue=in_Config("FilterValue").ToString.Replace("#Today#",DateTime.Today.ToString("d"))

That’s it

Thanks,
Ashok :slight_smile:

@Gopi_Krishna1 pls check below code

[Subject] = 'YourSubject' AND [ReceivedTime] >= Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd") + " 00:00:00") 
AND [ReceivedTime] < Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd") + " 23:59:59")