Email address checking solution for MS Access needed

I'm using Access 2K... but may soon be upgrading to Access 2016 or Office 365 so please do not let my current platform restrict your responses.
Obviously a solution that works with A2K is preferred.

My customer list now has more than 30,000 business email addresses.  These are all addresses were used to place orders, so at some point we know that all of the addresses were valid.

I would like to start a Mailchimp mailing campaign so I need a way to clean the list before attempting a mailing.  Can anyone recommend some code or an Access plug in.. or any other solution that can become part of my Access application... that will allow some sort of programmatic testing to mark hard, or possibly soft, bounces?

If not, any recommendations for a cleaning service would be appreciated.

Thank you.
pcalabriaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Only way to do that is send an email and see what happens, but that's iffy at best. Once you send the email, you don't really have much control over the return process (that's handled by the email client).

Your best best is to use a service like https://email-checker.net/, which has an API you can use to validate an email address, or https://www.mailgun.com/email-verification-service. These are all web-based services, so you'd have to become familiar with their preferred methods (like a RESTful method, or use of an web service, etc). Those can all be done from VBA, but how you do those depends on the web-based methods available fro the particular validation service.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
if you are using Outlook desktop, you can direct all the bounces to a folder and then link to that folder from Access. Then you can use an update query to mark the bad email addresses.
pcalabriaAuthor Commented:
@Scott  Thanks… I was hoping for code that might be able to check for dead_servers, mx records, etc.  I wound up using a service called EmailMarker.com mostly because they have the process automated, but two thirds of my list came back as "unknown" or other status which they consider too dangerous to email.... although review of these emails included my own company and some of our best customers.... Granted the dead servers and bad mx records are good addresses to remove... but it would have been nice to do more validation with Access than just format.... :-(

@Crystal  A routine such as this would be an awesome addition to our app... I never thought of that before... do you have any code to share?  I seem to remember lots of different bounce messages... it would be difficult to match up the bounce to the specific customer.
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
don't have code to share, sorry. You can write it yourself once you link to a mailbox, see what you can, and how you would do it manually. Start with the External Data ribbon tab, Import & Link Group ... once you use a newer version. Can't remember where it is for 2K ... poke around till you find it ~

All you really need from each bounce is the bad email address, which the body of the bounce should have. Once you have a list of email addresses not to use, you can update your other records accordingly.
John TsioumprisSoftware & Systems EngineerCommented:
Based on the "instructions" from Atomic Mail Verifier it seems that there could  way to do it from Access,
1 it get a function to retrieve mx records from the email domain and then
2.perform email verification via telnet..
From what i found there is also a program called EmailArchitect that has a classic VB api to integrate into your Access avoiding all the hassle...please note that i have not ever tested anything from the above
pcalabriaAuthor Commented:
@john. Thanks. I'll look into this to see if it helps. Btw.. your first link did not work.

@Crystal.  I'm not able to send these emails from outlook because our ISP limits how many emails we can send.  If I tried to send tens of thousands of emails..optimum online will shut me down... even if the email addresses were valid and legal to send to.

We plan to use MailChimp... but they may shut us down if excessive bounces occur.

So my Dilemma is that the email cleaning service (Emailmarker.com)  has marked at least 10k addresses in my list as too dangerous to send. The reasons listed are unknown or accept_all. Spot checking the list of don't sends finds it includes all my own companies email addresses and those of numerous customers that we know are valid.

I'm hoping I can take control of the situation with access to do additional checks before attempting a MailChimp mailing.  These are too many customer addresses to throw away
John TsioumprisSoftware & Systems EngineerCommented:
Probably there is some underlying code that somehow got in the way for my 1st Link ...so here it is again
As i see it the 2nd option is the best for you...just download the trial..copy paste the code from my previous post ...make the necessary edits and give it a spin...if it works ..i think the price is decent...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pcalabriaAuthor Commented:
Thanks. I used a combination of everyone’s suggestions. Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Mailchimp

From novice to tech pro — start learning today.