Validation in the email address textbox

**aman1234** · 08-25-2015, 06:40 AM

Hi Guys

I have a userform and in that there is a multiline textbox and Email Button. The user has to enter the email address/email addresses in that. I have written the note in a label that if there are more than 1 textbox then separate the email addresses using Semi colon sign ie. ; and when they press Email button then the code works and send the email across those email addresses but in case the user forgets to separate the email addresses using ; then no email gets sent out. I want to put the validation in multiline textbox so that if the email addresses are not separated using ; then throw an error message.

Please Login or Register  to view this content.

ANy help will be much appreciated.

Thanks

**Greg M** · 08-25-2015, 09:10 AM

Hi there,

Try the following code and see if it does what you need.

The code assumes that if Users do NOT use a separating semicolon, they will insert at least one space character between email addresses, and it checks to see if there is a semicolon immediately before that space. If no semicolon is present an error message is generated. Email addresses separated only by semicolons (i.e. semicolons NOT followed by a space) are considered valid.

Please Login or Register  to view this content.

You should note that if (for whatever reason) the code which sends your email crashes, the "On Error Resume Next" statement will prevent you from being aware of this! It might be better to use ".Display" instead of ".Send", so that at least you'll be aware that your expected email has not been displayed. If you'd prefer to have the email sent automatically, I can show you a code modification which will generate an error message if the email has not been sent.

Hope this helps - please let me know how you get on.

Regards,

Greg M