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 "[email protected]."
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
"[email protected],[email protected]" (no comma allowed) or
[email protected];[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.
 
Top