Distributing Total Access Emailer

Do you want to include email capabilities to applications you distribute to others? No problem! The Professional Version of Total Access Emailer  includes a programmatic interface to run email blasts programmatically from your applications, and distribute them to all your users Royalty-Free!

Best of all, it's extremely easy to use since all the complicated email blast specifications (data source, message format, field references, send options, etc.) can be defined and tested through the interactive Wizard. Programmatically, you simply need to reference the ID of the specifications.

Add Email to Your Access Application

Just follow these three simple steps to give your users the power to run email blasts at the touch of a button:

1. Define and test your email blast using the interactive Wizard interface.
2. Add a reference to the Total Access Emailer library from your database.
3. Add the Total Access Emailer function and reference the email ID you created in step 1.

For instance, all you need to add to your program to run email blast number 25 is this function call:

TotalAccessEmailer(25, False, "", "", True, True)

The function returns the number of messages sent.

Customizing the Email Blast

In addition to specifying which email blast to send, you can also customize how the blast is send with these parameters:

• RestartBlast- True to restart the email blast where it last ended, or False to start it from the beginning.

• DisplayType- Whether or how to display the progress of the email blast to the user which can be in a form or on the status bar.

• DisplayTitle- Your title for the display form and any messages if you don't want "Total Access Emailer" to appear.

• ShowResults- True shows the email blast results in a message box, False to hide this from the user.

• ShowErrors- True displays the errors table if errors are encountered. False still generates the errors table, but does not display them.

The email blasts and SMTP configuration are specified in tables edited from the Interactive Wizard. You can make copies of these tables so your users can't edit them from the Wizard, then specify the alternative names when you launch your email blast:

• EmailTbl- The main table containing the email blast settings.

• OptionsTbl- The table containing the Send and SMTP options.

• EmbedTbl- The table containing the embedded object options.

Distributing the Total Access Emailer Runtime

The Professional Version of Total Access Emailer includes a small setup program that distributes and registers the Total Access Emailer runtime. This program automatically installs and registers the Total Access Emailer redistributable files, along with its dependencies. Deployment couldn't be easier- just run the setup on your users' machines, and they're ready to use your application!

A separate runtime version is available for your Microsoft Access version:

• Access 97

• Access 2000

• Access 2002/XP

• Access 2003

• Access 2007

The runtime for Microsoft Access 2002/XP or Access 2003 works with database files in Access 2000 and Access 2002/2003 formats.

Microsoft Access 2007 Support

The runtime library in Total Access Emailer 2007 is in ACCDE format which supports any Access database supported by Access 2007 (MDB, ACCDB, and ADP) and the features of Access 2007 (such as reports as attached PDF files). A digitally signed Access 2003 runtime library in MDE format is available for distribution to Access 2003 users, who of course would not be able to use the Access 2007 features.