When one of the email addresses is incorrect and the message is not sent

[cynthixie]

Hi guys! I am working on an excel sheet to send multiple mails. Sometimes I am sending a message to many email addresses but often one of the addresses is not right or well written and for that reason the message is not sent. Do you know if there is any way to avoid this? For the message to be sent regardless of whether one of the e-mail addresses is incorrect.

pd: I apologise for my grammar mistakes, english is not my first language

 

[Logit]

Well ... the most effective approach would be to verify all of the email addresses prior to sending anything.

After that approach, if you go to Google and search for "vba email on error" you'll receive lots of example code to assist should there be an error in sending.