Do you want to include email capabilities to applications you distribute to others? No problem! The Professional Version of Total Access Emailer includes a VBA 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.
Just follow these three simple steps to give your users the power to run email blasts at the touch of a button:
For instance, all you need to add to your program to run email blast number 25 is this function call:
The function returns a blank string if successful or an error string if a problem was encountered.
For more information on the details of the procedure call, visit Sending Microsoft Access Email Blasts Programmatically using VBA.
To use the Total Access Emailer function, add the Total Access Emailer runtime file as a library reference from your VBA Tools, Reference menu:
VBA Library Reference to Total Access Emailer Runtime Library
The Total Access Emailer runtime library is TAEmailR.accde or TAEmailR.mde depending on whether your database is ACCDE or MDB/ADP format. There is also a 64-bit runtime library, TAEmail_64.accde, for the 64-bit versions of Microsoft Access 2010 or later.
The Professional Version of Total Access Emailer includes runtime distribution rights, so you can distribute your Microsoft Access application using Total Access Emailer royalty-free to non-owners of Total Access Emailer. The previous example shows the version for Microsoft Access 2016. Versions are also available to support Microsoft Access 2013, 2010, 2007, 2003, 2002, 2000, and 97.
Each PC that runs your database needs a one-time installation of Total Access Emailer files on its machine. We provide an EXE file to simplify this step:
This file is located in your installation directory. You can copy it to a network shared folder. All you need to do is run the EXE once on each user's machine, and they’re ready to use your application. The executable distributes the necessary runtime files to your user's systems and configures their computers to use Total Access Emailer in runtime mode.
Where the Total Access Emailer library file (TAEmailR.accde, TAEmailR.mde, or TAEmail_64.accde) is located depends on how you deploy your database:
If your database is used by one person at a time and located on the network, you can simply have your database reference the library file located in the same network folder. Just make sure the library reference is correct and not pointing to your library file located on your PC.
In a split database architecture with a front-end database installed on each user's PC and a shared back-end data database, you'll need to make sure your front-end "application" database properly points to the referenced Total Access Emailer library file. You don't need to copy the runtime library to each user's machine. Just store it on your network and set your reference to the file. To simplify and centrally manage the deployment and launching of your Microsoft Access database to each PC, consider our Total Access Startup program which comes with Total Access Emailer in the Total Access Ultimate Suite.
If your database goes somewhere else, referencing the runtime library on your network won't work. In this case, when you distribute your database, you also need to distribute the library file. Save the library file in the same folder as your database. This works no matter what folder name it's installed in. Microsoft Access automatically searches for the library references in the same folder if the original reference cannot be found.
"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