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=(”“”" like ‘%" & SenderMailVar & "%’)"

@Shubham_Varshney Try the below one :

"@SQL=("""" 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 <“”>
If I make the search on abc it’s coming in fine but the doesn’t work

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


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:

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

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?