email address validation

Hi Team,

Need a UDF to validate email address on the basis of below condition.

"all the special character before “@” are valid and any special character, except “dot(.)”, after “@” are invalid in an email"

Eg : 1abc#@TY123.com is valid
1abc#@ty-mail.com is invalid

Regards,
Ashok

Good morning Dominicb,
this is not giving output as per my condition mentioned

i have changed the pattern as per my need and it is working fine

objRegExp.Pattern = "^([a-zA-Z0-9_\!\#\$\%\`\*\+\-\/\=\.\?\^\'\~\{\}\|\&]+)@[a-z0-9]+(\.[a-z0-9]+)*(\.[a-z]{2,3})$"

Thanks