Efficient Email Bounce AutomationEfficient Email Bounce Automation

   Home > Resources > How-To Articles > Article 2 - Simple Email Bounce Automation - Part 2
 

Simple Email Bounce Automation Using BounceStudio Enterprise
Part 2 of 2


Introduction

In Part 1 of this article, I showed you how to log your email bounce data to a table within a Microsoft Access database. 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 Visual Basic 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.

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.

Overview

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 btBounceLog 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. BounceStudio 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.




Page: 1 | 2 | 3 | 4 | Continue to Page 2 >>






"Thanks for a quality and value-for-money product. Incidentally it is desperately easy to interface with the BoogieBounce API from a PHP script."


Alex Poole
Infogrames
©1999-2020 BoogieTools, Inc. All rights reserved.