Solved

email list cleanup

Posted on 2012-04-09
5
278 Views
Last Modified: 2013-11-18
what is a good software to clean email lists ?
0
Comment
Question by:goodluck11
  • 2
  • 2
5 Comments
 
LVL 32

Expert Comment

by:DrDamnit
ID: 37826227
Umm.... it's a little more complicated than that. What's wrong with your list?
0
 

Author Comment

by:goodluck11
ID: 37827870
Its old, has bounces, and not sure many are correct. There are programs for this, not sure which one actually works.
0
 
LVL 33

Expert Comment

by:shalomc
ID: 37848738
You have 2 issues.

Deduplication is easy, and can be done by any semi-competent dba or programmer. Any program that promises deduplication is likely to work.

Validation is hard. You have to actually send email to all of the list, track bounces, and clean the list accordingly. It is a whole process that takes a lot of time and effort.
I wouldn't trust packaged software that promises to easily validate your list. I would try to use a service that may already have validated millions of emails and validates by crossing your lists with their lists.

In any case, please don't do the despicable practice of using a return address out of your domain, dumping the bounces and rejects on innocent 3rd parties.  Pricks who do that eventually run into crazy bloodhounds like me who know how to track and how to bite :)
0
 

Author Comment

by:goodluck11
ID: 37854098
Thanks, but there has to be some good software out there to text valid emails...?
0
 
LVL 33

Accepted Solution

by:
shalomc earned 500 total points
ID: 37854873
the trick is in the word "good".

It seems easy to ensure that an email address is syntactically correct,  
BUT:
Does the domain exist?
Is the user a valid user on the domain?
Is the mailbox open to receive new incoming mail?

There is a technique to "knock on the door" of the target mail server using the SMTP protocol and the RCPT TO verb, but today most of mail servers will accept any email to their responsible domain, and bounce it later if it is invalid.

Validating a large number of emails is a challenging process, and not technically trivial, and I have grey hair :)

If you are serious about cleaning your email distribution list, I suggest that you find a service that specializes in this business and that you can trust to do this for you.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
REXEX help Part 2 2 38
VB.NET 2008 - SQL Timeout 9 34
Help with preventing selection from a combobox 11 34
How to repeat the data 4 17
Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question