The Most Powerful Microsoft Access Email Program Just Got Better with Version X.6!

When we introduced Total Access Emailer for Microsoft Access 2010 (version 14.0), we created X.6 versions to include its new features into Total Access Emailer for Access 2007 and earlier.

New versions of Total Access Emailer are now available:

  • Version 12.6 for Access 2007 (Note: A newer Version 12.7 is available for Access 2007)
  • Version 11.6 for Access 2003
  • Version 10.6 for Access 2002
  • Version 9.6 for Access 2000

Existing customers with a current priority support agreement receive free upgrades. Customers without a support contract can upgrade for a nominal fee. Here are the enhancements:

Automatically compress all your file attachments into one zip file that is emailed to your recipient. You can even add a password for additional security. These features are on the Attachment tab when editing an email blast:

Compress all your email attachments into a zip file with password

The name of the zip file and password can be explicitly provided (example above) or use values from fields in your data source to create a unique file name and password for each recipient:

Compress all your email attachments into a zip file with password

Total Access Emailer now supports field references for embedded object names. Previously, the object names were fixed values. Now you can use the value from another field for all or part of its name.

For instance, you can have a report attached as a PDF file named "Invoice[InvoiceID].pdf" and have the value in the InvoiceID field be part of the file name.

Additionally, when specifying the output format of an attachment, the extension for the file name is automatically changed based on your selection. So switching from HTML to PDF automatically updates the file name from a *.HTML to *.PDF. If you give your file name a non-standard extension, it is not modified.

Total Access Emailer supports text and HTML emails containing non-Roman, international characters including double byte characters such as:

  • Arabic: النص العربي
  • Chinese: 中文文本
  • Greek: Ελληνικό Κείμενο
  • Hebrew: עברית טקסט
  • Hindi: हिंदी पाठ
  • Japanese: 日本語テキスト
  • Korean: 한국어 텍스트
  • Persian: متن فارسی
  • Russian: Русский текст
  • Urdu: اردو متن

An example of a Continuous Emailer Service is provided to support a table driven system to continuously send emails within your Microsoft Access application. New emails can be added to the table manually or triggered by another action in the application for e.g. new order, due date, etc. When the database opens, you can open the form automatically through an Autoexec macro or naming the form as the startup form.

The new Code Generator lets you interactively select options and build the VBA code to run the currently selected email blast in your application. Simply set your options and paste the code into your module to send and/or preview your email blast.

VBA Code Generator for Automating Email Blasts from Microsoft Access databases

Several new VBA functions are available in the Professional Version to provide more options and control for VBA developers. For additional details, visit Sending Microsoft Access Email Blasts Programmatically (VBA):

Send One Email

Rather than creating an email blast from the Total Access Emailer add-in, a new function, TotalAccessEmailer_SendOne, lets you specify the information for sending one email. Provide the FROM address, TO address, subject, message, etc., and the email is sent using your SMTP settings.

Preview Email Blasts

In addition to sending email blasts, you can also preview the emails by sending them to an email of your choice along with the number of records to process. This is similar to the interactive Preview feature from the add-in which you can now incorporate in your application.

Update and Test SMTP Settings

Two new procedures, TotalAccessEmailer_SetPasswords and TotalAccessEmailer_SMTP_IsValid, let you specify the passwords and test the SMTP settings. The sample database includes a form you can import into your application to give your users this feature as well.

The Professional Version of Total Access Emailer includes a VBA programmatic interface that lets you add email blasts to your Access applications and distribute them royalty-free.

Version x.6 includes new files for the Access add-in. It also has new runtime library files:

  • The Access 2007 version includes an ACCDE runtime library for ACCDB databases, and an MDE library for MDB databases for Access 2003 and 2007 users
  • The Access 2003 version includes a runtime library for Access 2002-2003 database formats, and another library for Access 2000 and 2002 users
  • The Access 2000 and 2002 versions include one runtime library that support Access 2000 and 2002.

Silent Installations

When deploying the runtime version of Total Access Emailer, the executable program to run on the userís machine can now be invoked without the user seeing it. Use the silent command line parameter "/s" when running TAERun32.EXE.

If you are using a version before we released the Access 2007 version, there was an X.5 version with many new features described here: Version X.0 to X.5 Enhancements. All of those enhancements are included in the X.6 version.

A functional demo version is available for you to try Total Access Emailer on your data. Download a trial version

If you want to look at how it works without installing the program and review the calculations it generates, read the user manual for more details of these and other Total Access Emailer features. A context sensitive help file is included in the program and trial.

Microsoft Access Email Documentation

Microsoft Access 2016 Version is shipping!

New Features

New X.7 Versions for Microsoft Access 2013, 2010, and 2007!

X.6 Versions for Microsoft Access 2003, 2002, and 2000

View all FMS products for Microsoft Access All Our Microsoft Access Products


"I was thrilled with how easy it was to run and I appreciated that I didn't need to build any special tables or queries."

Sandra Daigle
Microsoft Access MVP

Emailer Info

Additional Info



Free Product Catalog from FMS