VBA Code to email multiple people and code to go to the next email if error occurs

Does the current code only sent emails to individual recipients?

When would you want to sent emails to multiple recipients?

What error(s) would you be expecting to encounter?

If using outlook, you could create a email list in a column in separate sheet and use code to add those email addresses to the email. If there is an error, such as an email wasn't sent, you should automatically get an email notification that it didn't send.

Originally Posted by pmeltzers

I have a code that sends out multiple emails to people in one swoop! it is really awesome actually.

Please post awesome code as a starting point for discussion.

Originally Posted by pmeltzers

I need for it to tell me if there is an error (if this is true) that it is due to the email address not being valid...

VBA can determine if the email address is well-formed before trying to send (e.g., using fred.gmail.com as an email address). What do you mean by "not being valid"?

VBA code cannot determine if an email fails to be delivered. If an email address is not valid there are multiple things that can happen, none of which is a synchronous response back to the VBA process. Here are the most common:

• Invalid domain name. The sending SMTP or Exchange server will reject the outgoing email. You may get a bounce notice at your client.
• Invalid username. The receiving SMTP server will reject the incoming email. You may get a bounce notice at your client, but many servers will not report non-existent email addresses.
• Mail can't be delivered (e.g., full mailbox). The receiving SMTP server will reject the incoming email. You may get a bounce notice at your client, but many servers will not report undeliverable email.