excel 2016, How to apply like, to search and exclude for email addresses, in a URN filter?

[aamyra]

hi

I need to search sender e-mail address excluding microsoft and no-reply@notify.aol.com for a date.

This code work for microsoft only.

Filter = "@SQL= (NOT urn:schemas:httpmail:fromemail like '%microsoft%'" & _
          " And urn:schemas:httpmail:datereceived = " & daterec& "))"

But when am adding the no-reply@notify.aol.com to exclude, the list is blank.

 Filter = "@SQL= (NOT urn:schemas:httpmail:fromemail like '%microsoft%'" & _
                    " And(NOT urn:schemas:httpmail:fromemail  = 'no-reply@notify.aol.com'" & _
          " And urn:schemas:httpmail:datereceived <= " & daterec& "))

"

What wrong in the condition? help!

 

[aamyra]

Any help pls