Click here to Skip to main content
12,947,379 members (49,114 online)
Rate this:
Please Sign up or sign in to vote.
Hello friends,
I have list of about 400,000 mail address belong to my customers
loaded in oracle database.

How can i validate this lest in easy way.
(see if this email is exist or not ??? )

thanks alot
Posted 23-Feb-13 2:24am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You can validate the domain name portion of the email address using a DNS Lookup. I did this many years ago using a component purchased from MelissaData.

No Easy Way
I know of no way to validate individual email addresses without sending them an actual email message ("Click here if you want to stay on our emailing list").

Bouncebacks indicate that the mailbox was unavailable. It is not foolproof because their mailbox server could have been offline and some companies have turned off the bounceback capability of their mail server.

If you send them a message, you could put a reference to a uniquely named image (one for each email address) in each email message and mine the W3SVC logs to record attempts to load those uniquely named images. The image does not have to exist on your server. This is not foolproof because some people have image loading turned off in their browsers and some people delete email messages without reading them. Check with your company's attorney before doing this as some companies have strict policies on email messages sent from the company to customers.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

The SMTP protocol supports the VRFY command which can be used to verify an email address. Sadly enough it has been misused by spammers to harvest emailaddresses or by hackers to harvest usernames. So it's been disabled on many mailservers, and some servers might even blacklist you if you use it to many times.
But it might be worth some research.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,059
CHill60 3,235
Maciej Los 2,538
Jochen Arndt 1,935
ppolymorphe 1,795

Advertise | Privacy | Mobile
Web01 | 2.8.170518.1 | Last Updated 23 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100