VBA solution to validate email address syntax

The attached file has a VBA function to test the syntax of an email address. This validation conforms to all elements of the standard except:

• Nested comments are allowed by the standard but will result in a false negative
• Quoted strings are allowed by the standard but will result in a false negative

Feel free to note any failure cases that you find.

Hi, I have this valid emailaddress that gives a False too: <[email protected]> (this is just copied from Windows10 messenger)

I know this < maybe not part of an emailaddress but my program swallows it

Cheers
Erwin

I will have to think about this one. Technically the < > characters are not part of the email address and are in fact illegal in an email address, but mail clients use this notation to allow specifying a display name

FirstName LastName <[email protected]>

The parser could be modified to recognize this. I'll look at this.