Filter mail outlook?

Help Activities
, ,
1

Example header mail : Sun, 23 May 2021 17:01:09 +0700

I want to filter mail receive time from today 17.00.00 - 17.10.00

Please guide me about it.

2

@fairymemay - Could you please share the similar screenshot of yours?

image
image1281×197 11.2 KB

This is just to make sure, your header date format is correct before proceeding.

3

@prasath17

image
image1021×399 19.7 KB

4

@fairymemay - Thanks…Please check the below is working and you can extract the time alone using this command…Please run for atleast 5 mails…

image
image1242×388 19.6 KB

5

@prasath17
image

6

@fairymemay - I can see this query provided by @jack.chan is working for me…Could you please show me where exactly did you put this query with the screenshot?

7

@prasath17 If I use query for your mention.

“@SQL=urn:schemas:httpmail:datereceived > '” + Now.ToString(“dd/MM/yyyy 00:00:00”)+ “’ AND urn:schemas:httpmail:datereceived < '” + Now.ToString(“dd/MM/yyyy 10:00:00”)+ “'”

But output can’t show follow filter.

image

8

@fairymemay - I am asking for the similar screenshot…

image
image909×579 34.5 KB

9

@prasath17 My screenshot.

image
image998×428 24 KB

10

@fairymemay - Looks good…Can you change to time now , as per requirement and see the result?

11

@prasath17 What format time HH:mm:ss right?

12

Yes…

13

@prasath17 I change to query as below.

“@SQL=urn:schemas:httpmail:datereceived > '” + Now.ToString(“dd/MM/yyyy 17:00:00”)+ “’ AND urn:schemas:httpmail:datereceived < '” + Now.ToString(“dd/MM/yyyy 17:10:00”)+ “'”

but output not show (not found)
But If I remove filter and write line header , it show below.

14 
"@SQL=urn:schemas:httpmail:datereceived > '" + Now.ToString("ddd, dd MMM yyyy 17:00:00 +0700")+ "' AND urn:schemas:httpmail:datereceived < '" + Now.ToString("ddd, dd MMM yyyy 17:10:00 +0700")+ "'"

Please try this…

15

@prasath17 If I change filter follow you recommend.
I think it read all mail not filter time and date as below.

16

@fairymemay - In your case it should have resulted 0. because since you are running this today there won’t be any email at 17.00 and 17.10. Could you please change the filter time to 00:06:00 and 00:06:30 and try… and after the please share the screenshot of the filter properties…

17

@prasath17 I change time to 00:06:00 and 00:06:30 as below.

image
But output same.

image