I need help writing a code....

[Guest]

Hi there, need help writing a code that checks if the e-mail entered in a
filed is proper ([email protected]) or any possible ending of e-mail
address...

Hope to get help, this is for my project....

Thanks!

 

[Michael Bauer [MVP - Outlook]]

Use the InStr function to check if some necessary letters exist. The Len
function tells you the length of a string.

the address
- must have exactly one '@'
- must have a '.' after '@'
- must have two to four characters after that dot

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Wed, 27 Jun 2007 13:28:00 -0700 schrieb Shawn: