Email address checking solution for MS Access needed

pcalabria
pcalabria used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
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 Programming
Top Expert 2015
Commented:
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.

Author

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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
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 Engineer

Commented:
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

Author

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
Software & Systems Engineer
Commented:
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...

Author

Commented:
Thanks. I used a combination of everyone’s suggestions. Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial