Detecting email format in text field

C

Chris

I have a database which can do a mail merge. The problem is that the
mail merge will stop if there is an email such as "(e-mail address removed)."
because this email has a dot at the end. In the email field, the user
can enter multiple emails by using a ";" to seperate the emails
however mail merge will also stop if i have emails such as
"(e-mail address removed),[email protected]" (no comma allowed) or
(e-mail address removed);[email protected],". Can anyone give me a function that
can see if an email is in a correct format? It will be good if the
function can correct the mistakes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top