Avatar of pcalabria
pcalabria
Flag for United States of America asked on

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.
MailchimpMicrosoft 365Microsoft Access

Avatar of undefined
Last Comment
pcalabria

8/22/2022 - Mon
SOLUTION
Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
crystal (strive4peace) - Microsoft MVP, Access

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
pcalabria

ASKER
@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.
crystal (strive4peace) - Microsoft MVP, Access

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 Tsioumpris

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
pcalabria

ASKER
@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
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
pcalabria

ASKER
Thanks. I used a combination of everyone’s suggestions. Thanks