Email Bounce Automation Using BoogiePOP Enterprise - Part 1 of 2
page 2 of 5
by Scott Wolfington
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 28769/ 76

Creating Your Email Bounce Log Table In Access

If you downloaded the MS Access 2000 database provided on page 1 of this article, then skip to the end of this page by clicking here.

The first thing you need to do is create your email bounce log table within your MS Access database. You can create the email bounce log table in an existing database that you are already using, or you can create a new one. The database I'll be using for this article is one that already exists and is something I use quite regularly. Either way, using your Microsoft Access application, you'll need to create the new table with the following attributes.

Table Name: bBounceLog
Field NameData TypeField SizeIndexedAllow Zero LengthDefault
BounceLogIdAutoNumberLong IntegerYes (no duplicates)  
BounceTypeText4Yes (duplicates ok)no 
PopAccountNameText20Nono 
EmailAddressText255Noyes 
RawMessageTextMemon/aNoyes 
InsertDateDate/Timen/aYes (duplicates ok) Now()
ProcessedNumberLong IntegerYes (duplicates ok) 0
Note: The table name is prefixed with the letter "b" to help insure we don't create a table name that
may already exist in your database. The 'b' stands for BoogieTools.


When you are done adding the fields to your new table, you should see a screen that looks similar to the image below. Click File-Save, and when prompted for the name of the table, enter bBounceLog. You can ignore the dialog box that appears stating "there is no primary key defined". Just click the "no" button. You can make the BounceId field the primary key if you would like, but it is not necessary for this article.




After saving your new table, you will see a table named bBounceLog in the Access database window (see image below). Note that you see a couple of extra tables in the image below too. These tables existed in my database before creating my bBounceLog table. The table called "EmailList" is the table that stores all of my opt-in email addresses. You may or may not have additional tables in your database. I'll use these additional tables in Part 2 of this article.




Write Down Your Database Name And The Folder You Saved It Too

Before continuing, make a note of your MS Access database name, and the windows folder where you saved it. For instance, the name of my Access database is email.mdb, and I saved it in my c:\temp folder. You'll need this information later on in this article.






View Entire Article

User Comments

Title: help needed regarding BoogiePop installation and setting up   
Name: Rakesh Verma
Date: 2007-12-24 1:21:55 AM
Comment:
Dear sir,

i am describing below my requirements and my experience with boogietools

case: i have an clasic ASP written website, i want to track bouncing mail address when i send newsletter to a list of mail id's.

my Experience : i installed "BoogiePop Enterprise Setup" and followed steps in
http://aspalliance.com/375_Email_Bounce_Automation_Using_BoogiePOP_Enterprise__Part_1_of_2.all
but unfortunately i could not get Pop Log under tree structure i can see "Bounce Service" and "Smtp Service" links over there.


my assumption : what i think is when you set up all settings and installed "BoogiePop
Enterprise Setup" on server then it will save all bounced mail id's to Access Database which have fields described in your article.

i am not sure BoogiePop is helpful in my case or not.
please guide me if i can use BoogiePop to fix my website.
also please describe me its price and subscription process.

my mail id is
rakesh.verma@dotsquares.com

Regards
RAKesh vermA

Product Spotlight
Product Spotlight 





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


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-05-23 3:05:43 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search