Email Validate

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

Robert Raley

Access 2003

I would like to run a query to select the Email that are not in a proper
format for Email. Any one have and Idea how to do this.

Thanks

Robert M. Raley
 
Hi,

You might not be able to catch all of them (like international or TV email
addresses for example). However, an expression like the following might be
of help to get you started.

IsValid: IIf(InStr(1,[EmailAddresses],"@") And Right([EmailAddresses],3) In
('com','org','net','edu','gov'),-1,0)
 
Back
Top