Link to home
Start Free TrialLog in
Avatar of pcalabria
pcalabriaFlag 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.
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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.
Avatar of crystal (strive4peace) - Microsoft MVP, Access
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.
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
@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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks. I used a combination of everyone’s suggestions. Thanks