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

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

Thanks!

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:

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

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

Thanks!