We help IT Professionals succeed at work.

Email address checking solution for MS Access needed

256 Views
Last Modified: 2019-03-13
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

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

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.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
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
CERTIFIED EXPERT
Distinguished Expert 2019

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
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.