Validating Email using VBA

[MrHydrant1857]

Good morning all,
I have a list of emails that I am using to send emails through excel. However as I am sending emails I get a few "Mail Delivery Subsystem" kick backs. I am wondering if there is a way to use VBA to catch these emails that are not valid before sending? its not so much the format of the email as it is more the actual email is no longer valid. any help would be greatly appreciated!

 

[6StringJazzer]

There is no way to determine in advance if an email address actually exists. It's not a VBA issue, it's just the way SMTP works. In fact, if you do not get a bounce message you can still not know for certain if the email address exists, or even if your email reached its destination.