Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   I need help writing a code.... (http://www.outlookbanter.com/outlook-vba/51402-i-need-help-writing-code.html)

shawn June 27th 07 10:28 PM

I need help writing a code....
 
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!

Michael Bauer [MVP - Outlook] June 28th 07 07:34 AM

I need help writing a code....
 


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!



All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com