 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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:
- Configure Visual Basic Script (vbscript) to monitor btBounceLog table in your MS Access database (see download below)
- Configure Windows Scheduler to execute vbscript every 2 minutes
Pre-Requisites:
- Completed Part 1 of this article.
- BounceStudio Enterprise installed prior to starting.
- You have Microsoft Access 2000 installed.
- Windows 2000 or later
- 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 >>
|
|
 |
|
|
|
|
|
