Date Filter in Outlook

Sure @supermanPunch give me some time on this

@Shubham_Varshney Sure. No Problem

Pardon me for the delay in response:

“@SQL=(”“http://schemas.microsoft.com/mapi/proptag/0x0065001f”" like ‘%" & SenderMailVar & "%’)"

@Shubham_Varshney Try the below one :

"@SQL=(""http://schemas.microsoft.com/mapi/proptag/0x0065001f"" like '%"&SenderMailVar &"%')"

I think the Spaces matter

Still the same response :frowning:

It’s working fine with me mentioning the email id demotion of the person
Example: abc <“abc@gmail.com”>
If I make the search on abc it’s coming in fine but the abc@gmail.com doesn’t work

@Shubham_Varshney I thought the “like” operator covered that :thinking: It’s a Strange behaviour.

True!!!

That’s what I am trying to cover now!!!

@ppr you were correct I was using the chr(4) wrong
After I fixed it, it did work but now it’s erring out at sender’s email address

@Lahiru.Fernando @Palaniyappan @loginerror @balupad14
Can you please help me out with this query :frowning:

@Shubham_Varshney
can you please your latest Filter expression statements and status with us. So we can pick up for further checks.
Thanks

I am using the following now:

"@SQL=(""urn:schemas:httpmail:sendername"" like '%"&SenderMailVar &"%')"

1 Like

@Shubham_Varshney Did it work ?

Naah it’s not picking via mail id, but from the mail user name!!!
Which would beat the purpose of the automation :frowning:

had you tried also urn:schemas:httpmail:fromname?