Email Bounce Automation Using BoogiePOP Enterprise - Part 2 of 2
page 1 of 4
Published: 12 Mar 2004
Unedited - Community Contributed
Abstract
In Part 1 of this article, I showed you how to log your email bounce data to a table within a Microsoft Access database, using BoogiePOP Enterprise by BoogieTools. For some people, logging their email bounce data to a single table will be all they need, but for others it may only be 1/2 of their solution. In Part 2, I'm going to take you a step further and show you how to automate the process of updating your email list table(s) by using a simple VB script and the Windows Task Scheduler. In addition, I'll show you how to forward your non bounce messages (NB) via email to an email address of your choosing using CDONTS, an email object that is built into Microsoft's Internet Information Server.
by Scott Wolfington
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 37380/ 123

Overview
Everyone handles bounces a little differently, but I always recommend keeping a tally of the number of times each email address bounces. For instance, create a "BounceCount" field in your email list table and increment it every time an email address bounces. If the "BounceCount" field reaches a value of 9 (you can use any number here; 9 is an example), then this is when I remove the address. I treat different types of bounces differently. For example, if an email address hard bounces, then I'll increment it's "BounceCount" field by 3. If an email address soft bounces, then I'll only increment it's "BounceCount" field by 1. You can weight each bounce category any way you'd like.

I'm using Microsoft Access 2000 for my database, but the principles within this article apply to any database system you may be using.

There are 2 steps to automating this process. They include:

  1. Configure Visual Basic Script (vbscript) to monitor bBounceLog table in your MS Access database (see download below)
  2. Configure Windows Scheduler to execute vbscript every 2 minutes
Pre-Requisites:
  1. Completed Part 1 of this article.
  2. BoogiePOP Enterprise installed prior to starting.
  3. You have Microsoft Access 2000 installed.
  4. Windows 2000 or later
  5. Internet Information Service (IIS) installed (for email forwarding option)
Download:

Download the zipped vbscript file from here, and unzip the BounceHandler.vbs file to your local hard drive. If you didn't download the support database from Part 1 of this article, then you'll want to unzip the email.mdb database too.


View Entire Article

User Comments

Title: Mr.   
Name: Manish
Date: 7/23/2012 8:28:17 AM
Comment:
fine
Title: Mr   
Name: JITENDRA
Date: 3/4/2006 4:32:03 AM
Comment:
Hi,
this ia good one.
Thank You
Santosh
Title: hello   
Name: santosh
Date: 5/5/2005 8:06:36 AM
Comment:
Hi,
this ia good one.
Thank You
Santosh






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 4/23/2014 4:02:27 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search