The latest update for Total Access Emailer 2016 is:
16.01.0016 (released August 2018)
This update is available free of charge to registered owners of Total Access Emailer 2016. Notification and download instructions for receiving the update were emailed to registered owners. If you did not receive instructions, please contact us so we can update your information.
Before installing the update, make sure Total Access Emailer is not running:
Run the update setup file. It asks you to confirm that it will update your installation. You do not need to reenter your serial number.
The Professional Version includes library files you can reference with VBA in your Access databases to automate emails blasts:
The update program installs new versions of those files in the Total Access Emailer installation folder.
If you previously copied those library files to another location, you'll need to copy those files manually. If you don't replace those files, those deployments continue to run without a difference.
In Build 14, your SMTP server was validated by using your login email address as the FROM address rather than our fmsinc.com email address. That worked in most cases and eliminated the need to use a Temail.txt file.
Unfortunately, it caused some problems for certain servers that were previously working with our original approach. We've re-implemented our original technique for testing your SMTP server if your FROM address doesn't work or isn't provided.
When sending an email blast, the FROM address is now validated for proper syntax. This makes it much easier to identify problems when the FROM address is defined in a field or file.
Total Access Emailer verifies your SMTP server by sending a test email when you start an email blast and when you save SMTP settings under Options. By default, it sends an email from our test email address (firstname.lastname@example.org) to that address. This may cause problems for some SMTP servers that reject relaying emails with our address as the FROM address. In previous builds of Total Access Emailer, we provided a workaround for this by letting you include a Temail.txt file with an alternate email address. That email address was used as the FROM and TO address for the test. This is now simplified.
Total Access Emailer now uses the email address you specify in your SMTP settings as the FROM address and sends a test message to our email@example.com address. For instance, in the example below, the FROM address is MyName@MyDomain.com eliminating your need to specify that in a Temail.txt file.
Setting SMTP Settings in Total Access Emailer
If you do not want to send the test email to our email address, you can override this by creating a TemailTo.txt file with an alternate email address. If you choose this, make sure the email address is not in your domain, as the SMTP test should be testing an external email address. A successful email to an internal account does not validate sending an external email.
If your SMTP server doesn't require a logon name, you can still set the Logon Name to the email address you want for the FROM address. If you specify a Logon Name without a password, it is ignored for logging into the SMTP server. The Manual and Help file are updated with this information.
When viewing the datasheets, if you change the column settings, sort order, and/or filter they are saved where appropriate for the next time you open the form.
For the main list of email blasts, changes you make to the column widths, column order, sort order, and/or filter are preserved the next time you start the Total Access Emailer add-in. This makes it easy to display your most common email blasts in the order you want them displayed.
To see all your saved email blasts, remove the filter. You may also need to do this if you create new email blast or duplicate an existing one, and the new settings aren't included in your filter. Turn off the filter by clicking the Toggle Filter option from the ribbon or the datasheet navigation bar:
Column settings, but not filters, are preserved on other datasheet screens such as the lists when selecting multiple email blasts to send and view email blast results.
Preview lets you test your email blasts by sending the emails to your own email address. That lets you see exactly what your contacts receive including attached files.
While the preview is processing, it said it was "Sending Email ..." to your contact's email address, which was frightening to some. Rest assured, it never did that during the preview. To avoid confusion, the description now says "Previewing Email ..."
Explicitly Show that the Email is Being Previewed
This update includes the following enhancements:
Cc and Bcc values can be an explicit email address or a field reference. Explicit email addresses for the Cc and Bcc like "me@MyDomain.com" were being ignored. This is fixed.
This was an update for the 64-bit version only.
The original release for Total Access Emailer 2016 was 16.00.0008.
Updates are for registered users only and subject to the product licensing terms.
You may not re-distribute them without express written permission from FMS, Inc.
New X.7 Versions for Microsoft Access 2013, 2010, and 2007!
X.6 Versions for Microsoft Access 2003, 2002, and 2000
"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."
Microsoft Access MVP