Posts Tagged ‘email verifier’

How to Connect to a MySQL Database and Verify Email Addresses

How to Connect to a MySQL Database and Verify Email Addresses

The Advanced Email Verifier can connect to any ODBC compliant database, verify email addresses stored in a table in the database and save the verification results to the table.

Important! To save the verification results, you must create new fields in the database table like Status (type Integer), VerificationResult (type String), and LastResponse (type String).

To connect to your MySQL database from the Advanced Email Verifier, follow the steps below:

Step 1. Installing MyODBC Driver.

  • Download MySQL Connector/ODBC to your desktop computer making sure to select the appropriate installation file for your version of Windows. (Probably Windows Driver Installer (MSI))
  • After downloading, double click on mysql-connector-odbc-win32.msi.
  • When the MySQL Connector/ODBC – Setup Wizard window appears, click Next.
  • Select the "Typical" installation & click Next.
  • Click Install and wait for the installation to finish. Click Finish.

Congratulations! You have successfully installed MySQL Connector/ODBC.

Now you must allow the computer where the Advanced Email Verifier is installed to access your MySQL database by adding its IP address to the list of allowed hosts for your MySQL database.

Step 2. Adding MySQL Access Hosts.

  • Open your Internet browser.
  • Open the cPanel on the remote web server where your MySQL database is located
  • Click on MySQL Databases link
  • Scroll down the page and find "Access Hosts" section
  • Enter the IP address of the computer where the Advanced Email Verifier is installed
  • Click Add Host
  • Close your browser

Now you must create a user DSN for MySQL driver in the ODBC Data Source Administrator.

Step 3. Creating User DSN for MySQL Driver.

  • Click Start -> Settings -> Control Panel
  • Double click the mouse on Administrative Tools in the Control Panel
  • Double click the mouse on Set up ODBC Data Sources (32-bit)
  • Connect to a MySQL Database and Verify Email Addresses

  • On the “ODBC Data Source Administrator (32-bit)” screen click Add
  • Select MySQL ODBC 5.x.x Unicode Driver
  • Click Finish
  • Connect to a MySQL Database and Verify Email Addresses

  • Type Data Source Name, your TCP/IP server name, your username and password to connect to your MySQL server, and then select your MySQL database name
  • Connect to a MySQL Database and Verify Email Addresses

  • Click Test
  • Click OK if the test passes
  • Click OK to close the Connector/ODBC screen
  • Click OK to close the ODBC Data Source Administrator screen.

Now you are ready to connect to your MySQL database from the Advanced Email Verifier.

Step 4. Connecting to a MySQL Database from the Advanced Email Verifier.

  • Open the Advanced Email Verifier
  • Go to My Databases
  • Click on the New icon on the menu bar
  • Type a name for your database link
  • Click Select Database button
  • On the Data Link Properties screen select Microsoft OLE DB Provider for ODBC Drivers
  • Click Next
  • Select your data source name
  • Click on Test Connection button
  • Click OK if the test passes
  • Click OK to close the Data Link Properties screen
  • On the Database Manager screen select the Table Name from your MySQL database.
  • Map the fields from your MySQL database to the respective fields in the Advanced Email Verifier. To do this, click the mouse in the Mapped Field column and select a field name. The Email, LastResponse, and VerificationResult fields are mandatory for mapping.
  • Connect to a MySQL Database and Verify Email Addresses

  • Click OK to save the settings.

Step 5. Verifying Email Addresses from a MySQL Database.

To start email verification:

  • Put the cursor on your database name in the My Databases section
  • Click the “Start” button on the menu bar

Email List Validation: Why is it Important for Email Marketing

The importance of email list validation can't be exaggerated. But it’s often missed by businesses and individuals that go in for email marketing.

What does email validation mean? It's a process that verifies whether or not an email address is deliverable and valid. That is when you send an email message to a recipient, the message is actually delivered and does not bounce because of the invalid user.

Some marketers don't think bounce emails are a serious problem. However, it is. The primary reason why you should validate your email list is because the bounce rate directly affects your sender reputation.

Why MailChimp Suspended My Account

Why MailChimp Suspended My Account

MailChimp is known to work with an abuse-prevention system to make sure their infrastructure stays healthy and free of activity that violates the CAN-SPAM Act or their Terms.

So, if their abuse-prevention system or human team notices that something about your account or email campaigns raised a red flag, you will find your account suspended by MailChimp.

Below is a list of factors that could cause a red flag with MailChimp:

Best Practice of Bounced Email Handling

A bounced email is an electronic message returned to the sender because it was not delivered to the recipient for some reason. To understand possible reasons of email bouncing, let's go deeper into theory and trace the path the message takes from the sender's computer to the recipient's Inbox.

To reach the target recipient, the email message must successfully pass through numerous phases. Your email newsletter software sends the emails to your SMTP server or to your ISP SMTP server (it depends on the SMTP server you use). The SMTP server gathers the emails and puts them in a queue, then it sends the messages to the SMTP servers of your recipients' Internet Service Providers by establishing a conversation with the SMTP servers, i.e by connecting to the port 25 on the recipient's SMTP server. The recipient's SMTP server tells the sender's server if it is ready to receive the message or not. If it is not, the sender's mail server terminates the connection and will try again later.

Process Bounce Emails

How to Process Bounce Emails with the G-Lock Email Verifier

In the version 8 of the Advanced Email Verifier we added the Bounced Manager. Now you can use the Advanced Email Verifier to process those bad email addresses that could not be determined by the program during email verification and ensure that your list is 100% clean.

The Bounced Manager recognizes all types of bounce emails: hard bounce, soft bounce, mail block and abuse/fraud feedback reports. Plus, the Bounced Manager can determine transient bounce, challenge-response and auto-reply messages and delete them from the mail server.

Tip Use the Bounced Manager AFTER you verified your list, deleted bad email addresses from the list and sent the message to other email addresses that were classified as Unknown, Timeout or Greylisted. If some of these emails turn to be invalid, the message will bounce. Using the Bounced Manager you can save bounce email addresses to a file and then remove them from your list forever.

Follow the steps below to setup the Bounced Manager and handle bounce emails.

Step 1. Configuring Email Server Account.

Within the Advanced Email Verifier you create one or more accounts to process bounced emails from. An account defines where the program will read and retrieve messages from.

To create an account:

Click on Bounced Manager at the left pane.

Click on New Account under the Home menu on the toolbar.

Advanced Email Verifier - create account to process bounced emails

Type an account name. For example, you can use the email address you will process the emails from as the account name.

Select the account type: IMAP, POP3 or File System.

Enter the incoming mail server settings.

IMAP Server Settings

If your mail server supports both POP3 and IMAP protocols, it's recommended that you use the IMAP protocol. The speed of processing bounced emails from an IMAP account can be up to 7 times higher than from a POP3 account (the speed of email processing depends mostly on the quality of Internet connection, message size and other factors).

Server address: type your IMAP server name into this field.

If you are not sure you type the correct IMAP server name, check the account settings of your regular email client for the servers information. If you are not able to find the servers information within your email client, contact your ISP directly.

Port – 143

Login – your login name for the IMAP server.

Password – your password for the IMAP server.

IMAP Folder – click Retrieve to retrieve IMAP folders from the mail server and select the folder you want to process bounced emails from. If you do not select any folder, the program will process bounced emails from the Inbox.

IMAP Simultaneous Connections – set the number of simultaneous connections to your IMAP account. For example, Google allows maximum 10 simultaneous connections. If you use your regular email client to check your Google account, set 9 connections in the Advanced Email Verifier.

Process Seen Messages – check this option if you want to process seen messages too.

Mark Processed Message as Seen – check this option of you want to mark the messages as seen after they are processed.

After bounce is processed: – select the action what to do with processed bounced emails from the menu: Keep message on server, Delete message from server, or Move message to folder.

If you select "Move message to folder" action, then select the IMAP folder to move the message to.

If your mail server doesn't require secure connection, check the Default (No SSL) radio button.

If your server uses a security protocol, check the radio button: SSL or STARTTLS.

STARTTLS is the ESMTP keyword used to initiate a secure connection between two servers using the Secure Sockets Layer (SSL) (also known as TLS). Once the connection has been successfully established all further communication between two servers is encrypted. This means that the source and destination email address and the entire message content are all encrypted during the transfer.

Click Test to see if the account settings are correct.

Advanced Email Verifier - IMAP server settings to process bounced emails

POP3 Server Settings

Server address – type your POP3 server name into this field.

If you are not sure you type the correct POP3 server name, check the account settings of your regular email client for the servers information. If you are not able to find the servers information within your email client, you can contact your ISP directly.

Port – 110

Login – your login name for the POP3 server.

Password – your password for the POP3 server.

After bounce is processed: – select the action what to do with processed emails from the menu: Keep message on server, or Delete message from server.

If the server doesn't require secure connection, check the Default (No SSL) radio button.

If the server uses a security protocol, check the radio button: SSL or STARTTLS.

STARTTLS is the ESMTP keyword used to initiate a secure connection between two servers using the Secure Sockets Layer (SSL) (also known as TLS). Once the connection has been successfully established all further communication between two servers is encrypted. This means that the source and destination email address and the entire message content are all encrypted during the transfer.

Click Test to see if the account settings are correct.

Advanced Email Verifier - POP3 account settings to process bounced emails

File System

Select File System from the Account Type menu if you want to process bounced emails stored in a local or network folder.

Select the folder on the disk to process bounced emails from.

After bounce is processed: – select the action what to do with processed emails from the menu: Keep message in folder, Delete message from folder, or Move message to folder.

If you select "Move message to folder" action, then select a destination folder on the local or network disk to move processed bounced messages to.

Click Test to see if the account settings are correct.

After you entered your Incoming Mail Server settings, click on "Bounce Settings" tab.

Bounce Settings

Select the type(s) of bounce messages you want to process:

  • Hard Bounce: the email could not be delivered (ie. 550 Mailbox not found).
  • Soft Bounce: a temporary condition exists causing the email delivery to fail (ie. Mailbox size exceeds quota, host not found).
  • Mail Block: a bounce occurred because the sender was blocked.
  • Abuse/Fraud feedback reports: feedback loop messages sent when the recipient clicks "This is spam" button on your emails.

In addition, you can select the following types of emails for automatic deletion from the mail server:

  • Transient Bounce: transient message such as "Delivery Status/No Action Required".
  • Challenge-Response: auto-reply message sent by antispam software where only verified email addresses are accepted.
  • Auto-Reply/Out of Office Reply: an automatic response from the recipient (ie. Out Of Office, Vacation Message).

To save the Account settings, click OK.

Advanced Email Verifier - bounce settings

Step 2. Processing Bounced Emails.

To start processing bounced emails:

Click an arrow in the Check button under the Home menu.

Select the Account name.

Advanced Email Verifier - process bounced emails

If you added more than one account, you can click the "Check" button and the program will check all accounts at the same time.

The results screen will show the following information about bounced emails:

Email – email address which bounced

Type – bounced email type

Diagnostic-Code – error code

Original Subject – subject of the original email sent to the recipient

Date – date when the message bounced

The bottom panel in the Bounced Manager gives you the following information:

Account – email account name

# messages on server – the number of email messages (bounce and not bounce) in the mailbox

Processed – number of processed emails

Bounced Found – number of bounced emails found on the server

Added New – number of new bounce emails found since the last account check

Status – account status

Advanced Email Verifier - bounced handler

Step 3. Saving Bounced Emails to a File.

To save bounced emails to a file:

Click Save under the Home menu.

Select Hard Bounce, Soft Bounce, Mail Block, FBL Report or All from the menu.

Type a file name.

Click Save.

The program will save only email addresses to a file.

Advanced Email Verifier - save bounced emails to a file

To export bounced emails to a file:

Click Export under the Home menu.

Follow the steps of the export wizard.

The Export Wizard allows exporting the data the files of the following formats: Paradox, DBase, Text (.CSV), HTML, Excel, Word, SYLK, DIF, Lotus 1-2-3, QuattroPro, SQL script, XML, MS Access, MS Windows Clipboard, and ADO Connection.

During the export you will be able to select the columns you want to export to a file.

The program does not clear bounced emails from the screen automatically. Click on Clear button on the Bounced Manager toolbar to delete bounced emails from the screen.

AEV: Common Errors and Troubleshooting Tips

G-Lock Email Verifier: Common Errors and Troubleshooting Tips

When you verify email addresses using a direct Internet connection mode or web script, the verification returns the following statuses:

New – status 0

Good – status 1

Bad – status 2

Unknown – status 3

Timeout – status 4

GreyListed – status 5

Each of the statuses is linked to a server response which is shown in the LastResponse column. You can also see the full log of the email address in the Log panel. Select a line with the email address and a full log for this email address is displayed in the Log panel.

List of Common Responses

The following server responses are given when you verify emails using a direct Internet connection mode, web script or socks proxy servers.

If you verify emails through BPSocks email validation API, see the statuses and responses given by the API in this “How to Use Email Validation API” PDF Guide


Verification result: New


Result set by Rule
The program skipped the email address according to the rule. Go to Settings -> Rules to see the rules. You can read more about the email validation rules here.


Verification result: Bad


550 RCPT TO: User unknown
Such user does not exist.


550 No such user
Such user does not exist.


550 5.1.1 unknown or illegal alias:
Such user does not exist.


550 Invalid recipient:
The recipient's mail server returned the response that the user's email address was bad.


550 recipient rejected
The recipient's mail server returned the response that the user's email address was bad.


501 #5.1.1 bad address
The recipient's mail server returned the response that the user's email address was bad.


550 5.2.1 Mailbox disabled for this recipient
The mailbox for this recipient is not available anymore.


550 Mailbox is inactive
The mailbox for this recipient is not available anymore.


550 Mailbox unavailable or access denied –
The mailbox for this recipient is not available anymore.


Working MX record for domain xxxx.com is not found.
There are no MX records for the recipient's mail server in the DNS server.


Result set by Rule
The program did not verify the email address and automatically marked it as “Bad” according to the rule. Go to Settings -> Rules to see the rules. You can read more about the email validation rules here.


Verification result: Unknown


10060: Connection timed out
Most likely your ISP blocks the port 25 and does not allow you verify emails in the direct connection mode. Click on Settings, then click on the Connection tab in the Settings. Check the "Direct internet connection" option and click Test. If the test fails, you won't be able to use the direct connection mode. Consider using an alternate email verification method, for example, through the web script. If you know that your ISP does not block the port 25 but the direct connection test fails, make sure that you added Advanced E-mail Verifier (the aev.exe file) to the list of allowed programs in your firewall settings.


550 ERROR: Mail Refused
The IP address of the computer where the Advanced Email Verifier is installed is blacklisted.


553 Not delivered: Sender's IP blacklisted by njabl.org.
The IP address of the computer where the Advanced Email Verifier is installed is blacklisted.


554 combined.njabl.org blocked
The IP address of the computer where the Advanced Email Verifier is installed is blacklisted.


421 4.7.1 Rejected: listed as spam source at ZEN http://www.spamhaus.org/query/bl?ip=xx.xxx.xx.xxx
The IP address of the computer where the Advanced Email Verifier is installed is blacklisted. All ISP’s report their dynamic ranges to spamhaus. Anyone using the zen spamhaus list automatically blocks all email from dynamic IP addresses.


553 sorry, your mailserver [xx.xxx.xx.xxx] is rejected by Barracuda – http://www.barracudacentral.org/
The connection from the IP address of the computer where the Advanced Email Verifier is installed is rejected by Barracuda for security reasons.


554- (RTR:DU) http://postmaster.info.aol.com/errors/554rtrdu.html
The connection from the IP address of the computer where the Advanced Email Verifier is installed is rejected because the recipient’s mail server uses the Spamhaus PBL to block mail from dynamic and residential IP addresses.


554 Relaying denied. IP name lookup failed for xx.xxx.xxx.xx
Your IP address is blacklisted. AEV imitates sending a message from your computer to the recipient's mail server. SMTP servers can have anti-spam filters that refer to DNSBL lists to check the sender's IP address and if the IP address is blacklisted, the email is rejected. If you used the direct connection mode, consider using an alternate email verification method, for example, through the web script or email verification API.


550 Dynamic IPs/open relays blocked
The mail server doesn't accept connections from dynamic IP addresses or open relays. If you used the direct connection mode, consider using an alternate email verification method, for example, through the web script or email verification API.


451 Can't connect to – psmtp
AEV was unable to connect to the recipient's mail server at that time. Re-check the email addresses with this error later (in 5-10 min).


451 First-time sender tempfailed as anti-spam measure; please try again
To prevent spam, the mail server refuses the first connection. It is assumed that spammers don't try to send an email twice. Re-check the email addresses with such error later (in 5-10 min).


421 Service not available, closing transmission channel
Advanced Email Verifier was unable to connect to the recipient's mail server at that time.

1) Re-check the email addresses with this error later.

2) Switch the real time scanning of outgoing emails to OFF in your anti-virus software.


URL: http://www.yourdomain.com/aev7.php
Unable to parse response from script
Error. The password your entered is incorrect.
The error occurs because you verify emails through the script taken from a different computer. Go o the Advanced Email Verifier Settings -> Connection, click “Get Script” and re-upload the aev7.php file to your web server. Re-check email addresses.


Result set by Rule
The program did not verify the email address and automatically marked it as “Unknown” according to the rule. Go to Settings -> Rules to see the rules. You can read more about the email validation rules here.


Verification result: Timeout


10060: Connection timed out
The recipient's mail server didn't respond within the specified period of time (Timeout) and the AEV broke the connection to it. Increase the Timeout (Home menu -> Timeout) and verify the address later. If the address is still marked as Timeout, send an email to it. If the email bounces, the address is not valid.


Verification result: GreyListed


421 Message from [xx.xxx.xxx.xx] temporarily deferred – 4.16.50
The recipient’s mail server uses the “greylisting” technology and doesn’t accept the first connection due to security reasons.


450 4.2.0 <...>: Recipient address rejected: greylisted – wait some time and try again
Open the Advanced Email Verifier Settings (General) and check the "Recheck GreyListed emails in one session" option. Or, wait for 5-10 min and re-check GreyListed emails manually (Start -> Verify email addresses -> GreyListed).

 

G-Lock Email Marketing Bundle: G-Lock EasyMail7, Email Verifier & Email Processor

G-Lock Email Marketing Automation Bundle

G-Lock EasyMail7, Email Verifier & Email Processor for Windows

G-Lock Email Marketing Bundle

If you want to grow your business, you can't bypass email marketing. In the modern world companies and entrepreneurs who are using email as a successful marketing strategy need fast, reliable and cost-effective email marketing automation solution. G-Lock Software delivers you powerful software that suits perfectly for targeted bulk email marketing campaigns, email list management and email processing at your desktop.

G-Lock Email Marketing Bundle includes:

  • G-Lock EasyMail7 – Self-Managed, IN-HOUSE Email Marketing Automation Platform for Windows®
  • Advanced Email Verifier – Clean Your List from Bad Email Addresses and Invalid Domains
  • G-Lock Email Processor – Extract data from inbound emails. Automate your workflow within minutes and save valuable time.

G-Lock Email Marketing Bundle combines an unrivaled feature set with world-class support and virtually infinite flexibility, at a fraction of the price charged for competitive programs.

 

Buy Email Marketing Bundle and Save 15%!
Order processed by Avangate®


G-Lock EasyMail7 Email Marketing Automation Software

System requirements: Windows® Vista, 7, 8, Windows® Server 2008/12

Want the better way to stay in touch with your clients, prospects or subscribers and elevate your business to the next level, grow it and make it more profitable?

Try G-Lock EasyMail7 Today – Powerful, Self-Managed, IN-HOUSE Email Marketing Automation Platform for Windows® that works with any Email Delivery Services like Amazon SES, Sendgrid, Mailgun or your mail server.

Zero monthly fees saves you a fortune in email service providers costs.

G-Lock EasyMail7 ($159.00 USD price in bundle $135.15 USD)


Advanced Email Verifier Heps you protect your account from being blocked and send to Inbox

System requirements: Windows® Vista, 7, 8, Windows® Server 2008/12

Clean Your List from Bad Email Addresses and Invalid Domains and Increase Your Email Campaign Performance by Focusing only on REAL Prospects

You can use our Advanced Email Verifier to clean your list from invalid addresses before sending to it. Although it is simply not possible to guarantee a 100% accuracy level due to certain multiple factors beyond our control, the Advanced Email Verifier has a good email validation success rate. It can determine around 70-90% of bad email addresses and help you reduce your bounce rate.

Advanced Email Verifier ($99.00 USD price in bundle $84.15 USD)


G-Lock Email Processor Automated email processing and parsing software

gep main window 1 G Lock Email Processor

System requirements: Windows® Vista, 7, 8, Windows® Server 2008/12

Want a Convenient and Easy Way to Automate Processing of Incoming Email Flow, Without Spending a Single Minute of Your Working Time?

G-Lock E-mail Processor is used by businesses of all sizes to parse and extract data from messages, process email attachments, manage bounced and unsubscribe emails, convert message content into database records, process emails from local or network folders and much more, 24 hours a day, seven days a week.

G-Lock Email Processor ($595.00 USD price in bundle $505.75 USD)


Buy Email Marketing Bundle and Save 15%!

Order processed by Avangate®

 

Building your list, delivering email newsletters and grow sales with email marketing is the hottest sales lead generation trend on the web today. You want an email marketing solution that fits your email marketing goals and target audience, reduces the cost and complexity of your email marketing efforts, and ensures your success in online business.

No Commitment or Hidden Fees. Try it Risk-Free For 60 Days

Your investment is covered by our full 60-day, complete satisfaction, “love it or your money back” guarantee.

You can now safely and securely order our products and try it for 60 days at our sole risk! Your credit card information will be sent directly to the credit card processor via a secure (SSL)
channel so that no one can intercept your personal data.

E-commerce services is provided by Avangate® an e-commerce reseller.

Choosing Email List Verifier Software

Top 10 Questions You Should Ask Before Spending Your Hard Earned Dollars

Email marketing is one of the quickest and most cost effective ways to reach the target audience today. The more subscribers you have, the more you can profit from your list. But not only the list size does matter. To succeed in email marketing, you have to care about your list quality. You have to check the email addresses for validity and remove bad emails forever to avoid sending to invalid addresses, protect your email server domain from getting blacklisted and increase your email campaign performance.

There are many email verifier tools out there. How do you choose the best email list cleaner software? Follow these tips to avoid spending your hard earned money for a bad program.

Email Verifier

Clean Your List from Bad Emails on a Proactive Basis

When some Internet users move from one service provider to another, they do not take their e-mail addresses along with them. Users who lost their e-mail accounts may not notify you of their loss. Internet users may choose to subscribe to your service with a phony e-mail address so that they have access to a free download or a free offer that you may be offering online. Hence, you are left with dead e-mail addresses.

The AATools E-mail Verifier is your unique solution of the "message delivery error". It checks each email address from a mailing list and allows you determine up to 70-90 % of 'dead' mail addresses.

You don't need to disturb your clients and friends anymore to check if their email addresses are still valid. The E-mail Verifier connects directly to the recipient's SMTP server and checks it for you. Nothing is sent to the recipient.

The E-mail Verifier helps you decrease Internet traffic, because you can clean your list on a proactive basis avoiding sending to bad email addresses that would cause a ping-pong of useless messages between SMTP servers. In addition, the E-mail Verifier helps you save money. If you ultimately decide to use a commercial service to manage your list and send your newsletters, you will usually pay either by the number of sent messages or by the size of your list. If you handle the newsletter sending yourself, then it becomes a time issue. In either case, you will have to deal with bounced messages.

In addition, E-mail Verifier has the following features:

  • Multithreaded engine, that gives you high performance on checking.
  • Import of emails from .csv and .txt files.
  • Socks v4, 4A and 5 proxy support for LAN users  

Important! It is not recommended to load more than 2000-3000 email addresses for verification. If you want more advanced functions and power, try Advanced Email Verifier

AEV Survey: Ideas for New Version

What Do You Want in the Next Version?

G-Lock Software team continues the development of the Advanced Email Verifier and needs your help and input.

If you have been using the Advanced Email Verifier for a long time, or have recently downloaded the program for the first time, we would appreciate your ideas for software improvements or enhancements to functionality.

What do you love about Advanced Email Verifier? What do you hate about it? Tell us why you like it, why you don't, and why.

Tell us what features would make Advanced Email Verifier even better and vote for features that are most important to you.

Please, take just a few seconds and share your thoughts in comments below. Your suggestions can make a big difference, and will help us develop and improve the program and service for you.