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
@Shubham_Varshney I thought the “like” operator covered that 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
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 &"%')"
@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
had you tried also urn:schemas:httpmail:fromname?