The Most Powerful Microsoft Access Email Program Enhanced with Version X.81 for Access 2016, 2013, and 2010!
When we introduced Total Access Emailer for Microsoft Access 2022 (version 22.0), we created X.81 versions to include its new features into Total Access Emailer for Access 2016 to 2010:
- Version 16.81 for Access 2016
- Version 15.81 for Access 2013
- Version 14.81 for Access 2010
Existing customers with a current priority support agreement receive free upgrades. Customers without a support contract can upgrade for a nominal fee. The new versions are backward compatible so any email blasts you previously created will work with the new versions.
Version X.81 Enhancements from Version X.7
Transport Layer Security (TLS) for Office 365
In January 2022, Microsoft Exchange/Office365’s SMTP server and Windows increased the security requirements of TLS protocols.
The changes prevented TLS from working in prior versions of Total Access Emailer. They still supported other protocols like SMTP but not TLS.
Total Access Emailer adds additional security settings and supports new protocols including TLS 1.3. TLS versions 1.0, 1.1, and 1.2 were already supported.
Google Gmail OAUTH Protocol when App Password is not Possible
Beginning
June 2022,
Google Gmail stopped supporting SMTP to send emails by providing the email address and password.
Instead, a Google App Password is required to be used with multi-factor authentication (MFA).
For some Google Gmail accounts, MFA and/or App Passwords are not possible and the OAUTH protocol is required to send emails. Total Access Emailer now supports OAUTH for Google and your Google account.
Options Form, SMTP Settings Enhanced for Gmail Approval
The Options form’s SMTP Settings tab now connects with Google’s web site to approve your Gmail account:
When the [Approve on Gmail] button is pressed, a Wizard appears to launch the Google site. Once approved, Total Access Emailer can send emails through it using the TLS connection protocol. Prior to this, you need to create a Client ID from Google. For more information, visit Google Gmail API Account for SMTP Server for Total Access Emailer.
New Table usysTEmailerOptionsData
To support the Google Gmail credentials, a new table usysTEmailerOptionsData is added to your database. This saves the Google tokens for the connection. Just like the usysTEmailerOptions table stores the other SMTP settings and options, this table can be in another database and linked to it from your front-end database.
New and Modified VBA Procedures
For the Professional Version, to support the new Google Gmail OAUTH protocol, a new procedure TotalAccessEmailer_SetGmail lets you authenticate your users Gmail account, and other procedures are updated to include the new table.
Multiple FROM Email Addresses
Your SMTP server may have limits on the number of emails that can be sent by each email address.
By adding comma separated email addresses in your FROM address, Total Access Emailer rotates among them to spread your emails across multiple accounts.
Name1@MyDomain.com, Name2@MyDomain.com, Name3@MyDomain.com
Different Reply To Address
By default, the FROM address in your email is the same email your recipient sends their replies.
You can now specify a different email address for replies by adding -ReplyTo: at the end of your FROM address:
FromMe@MyDomain.com –ReplyTo:Another@MyDomain.com
This can also be added to the end of multiple FROM emails so their replies all go to one email address.
SMTP Validation No Longer Sends a Test Email
In prior versions, Total Access Emailer validated your SMTP settings by emailing a test message. This caused some problems if the FROM or TO addresses conflicted with the SMTP server or specific account. A new approach validates the SMTP connection without sending an email.
Relative Paths for File Names
File references for Subject, FROM address; Text Header, Body and Footer; HTML, and Attachments no longer need to be the full path. A relative path can be entered if it exists relative to the database’s folder.
This makes it easier to reference files if the database is installed on different drives and folders among users.
Main Form Enhancements Preserves Datasheet Settings
The main form has larger buttons and saves the settings of the email blast list.
Like standard Access datasheets, you can filter and sort the list, adjust the row height, resize and reorder columns, etc.
Those settings are preserved the next time you start the add-in. This makes it easier to customize its appearance for your needs, and display the blasts you’re managing.
Datasheet settings are also preserved in the form for selecting multiple email lists to send.
Edit Form Enlarged and Resizable
The edit form for email blasts is wider and taller, and can now be resized to be larger or even maximized. This is especially helpful to see more text on the message tabs.
This form was previously opened as a fixed dialog.
Embedded Files as Comma Separated Values (*.csv)
Total Access Emailer lets you attach files to your emails with data from a table, query or report. You can choose different formats like Excel, text, PDF, etc. A new format, Comma Separated Values (csv), is a text file that opens as an Excel spreadsheet.
Preview Settings are Preserved for Each User
The Preview feature lets you send emails to an email address so you can verify your emails are processed and formatted properly. If your PC has multiple users, the Preview settings are saved for each user rather than shared. This ensures your previews always go to your email address and don’t get mixed up with others
Updated Sample Database and Documentation
The sample database lets you easily update all the email addresses to your own. From the Windows menu, the shortcut for the sample database opens the database with the correct version of Access corresponding to your version of Total Access Emailer.
The user manual and help file are updated with the latest information.
Runtime Library Name Shows 32-bit
The Total Access Emailer Professional version includes VBA runtime libraries TAEmailR.accde and TAEmailR_64.accde for Access 32 and 64-bit respectively. When referenced, the name shows if it's 32 or 64 bit.
Reference to Total Access Emailer 2022 Runtime 32-bit
Reference to Total Access Emailer 2022 Runtime 64-bit
Previously, only the 64-bit one showed its bitness. Visit this page for details on Upgrading the Total Access Emailer Library for Existing Deployments.
Setup Program Supports 64 and 32-bit Access
Previous versions had a separate setup program for 64 and 32 bit versions corresponding to your Access version. The new setup contains both versions, detects the install Access version’s bitness, and installs the appropriate one. This requires Windows to be 64-bit which is already required for current Access versions
One Redistribution EXE
The Professional Version now has a single redistribution TAERun.exe file. For every PC that runs your database referencing the Total Access Emailer runtime library, the TAERun.exe file needs to be run once.
The TAERun.exe installs the 32 and 64-bit controls so you can use that whether your Office/Access version is 32 or 64-bit. In prior versions, there were separate 32 and 64-bit EXEs.
Download the Trial 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.
Total Access Emailer is available by Microsoft Access version.
|
Total Access Emailer Products for Microsoft Access |
|||||||||
| Licenses | Price | 365*, 2021, 2019 | 2016 | 2013 | 2010 | 2007 | 2003 | ||
|
Professional Version |
22.0 |
16.81 |
15.81 |
14.81 |
12.7 |
11.6 |
|||
| Single | $699 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
| 5 Seat | $2,099 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
|
Standard Version |
|||||||||
| Single | $399 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
| 5 Seat | $1,199 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
| UPGRADES (between DIFFERENT Access versions) | |||||||||
|
Upgrade from prior Access Professional version to Professional |
|||||||||
| Single | $399 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
| 5 Seat | $1,199 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
|
Upgrade from prior Access Standard version to Standard |
|||||||||
| Single | $299 | Buy Now | Buy Now | Buy Now | Buy Now | ||||
| 5 Seat | $899 | Buy Now | Buy Now | Buy Now | |||||
|
Upgrade from prior Standard version to Professional |
|||||||||
| Single | $549 | Buy Now | Buy Now | Buy Now | Buy Now | ||||
| 5 Seat | $1,649 | Buy Now | Buy Now | Buy Now | |||||
| UPDATES (within the SAME Access) | |||||||||
|
Update from Professional to Professional |
|||||||||
| Single | $299 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | |||
| 5 Seat | $899 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | |||
|
Update from Standard to Standard |
|||||||||
| Single | $299 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | |||
| 5 Seat | $899 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | |||
|
Update and upgrade from Standard to Professional |
|||||||||
| Single | $399 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
| 5 Seat | $1,199 | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | Buy Now | ||
|
Premium Support Subscription |
|||||||||
| Single | $299 | ||||||||
| 5 Seat | $999 | ||||||||
|
Also available as part of |
|||||||||
| Total Access Ultimate Suite | |||||||||
|
Runtime/Redistributable Version |
|||||||||
| The Professional version of Total Access Emailer offers a VBA Programmatic interface and runtime library. It includes royalty-free redistribution rights to non-Total Access Emailer owners. Use is subject to the terms of the license agreement. | |||||||||
|
* Office/Access 365 Support |
|||||||||
| Microsoft Office/Access 365 is a subscription that is constantly updated. Total Access Emailer 2022, version 22.0, supports the version of Office/Access 365 when it was released. We cannot guarantee automatic support for all future releases with our current version. We strive to provide upgrades to support new features as they become available. | |||||||||
|
Licensing Information |
|||||||||
| Total Access Emailer is licensed on a per user basis. Each user who runs the program must have a license. | |||||||||
Enhancements in Previous Versions
These are the enhancements introduced in earlier versions of Total Access Emailer:
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.
Total Access Emailer 2022 is shipping for Access 365/2021/2019!
New X.81 Versions for Microsoft Access 2016, 2013, and 2010!
X.7 Version for Access 2007
X.6 Versions for Access 2003, 2002, and 2000
Reviews
"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
