Total Access Emailer uses SMTP to send your emails from Microsoft Access. That requires you to have an SMTP email server that allows you to send emails from the FROM addresses you specify. SMTP is a standard email protocol that has existed for decades.
If you have an email account with Google Gmail, you have an SMTP server. As long as you abide by Gmail's terms and conditions, you'll be able to send emails through their SMTP server using your Gmail address as your From address.
A few years ago, Google changed Gmail so that you needed to explicitly allow it to let programs use its SMTP server by explicitly allowing it to use Less Secure Applications. This is described on our page Setting Google Gmail as the SMTP Server for Total Access Emailer and is fairly easy to implement.
Google announced that starting May 30, 2022, Less Secure Apps are no longer supported and a more secure protocol using OAUTH 2.0 is required. The protocol change impacts the security around your Gmail account. The Gmail password is no longer entered in the desktop application which is considered a security issue.
Instead, Google is switching to a new OAUTH 2.0 protocol that requires each application that uses it to be registered as an authorized Google application, and the Gmail account to approve using. This is similar to how web sites and phone applications use Gmail, but is less suited for Windows solutions.
We expected to register Total Access Emailer as an approved Google application for sending emails using SMTP. Unfortunately, Google is not approving any Windows applications as an approved SMTP program for external Gmail users.
You can only create a Google application for yourself that lists which Gmail accounts can use it.
NOTE: If you are only using one Gmail address and your account allows it, you can create an App Password to use in Total Access Emailer.
That is a lot simpler than a Google API client ID. Visit Google Gmail SMTP App Password
for details.
The following sections cover the steps:
Since we cannot create a Google API Client on your behalf, you have to create your own to use your Gmail accounts with SMTP. Because this is only for your organization or the Gmail accounts you specify, you do not need to go through the official Google approval process for public apps.
Most of the steps are identical for Internal and External apps.
After that, the latest versions of Total Access Emailer can send emails from your Gmail account.
The final Summary screen appears to confirm your app settings.
After creating the Google account with the Client ID and Secret ID, you are ready to enter them into Total Access Emailer on the Options, SMTP Settings tab:
Total Access Emailer is now able to send emails with your Gmail account through the Gmail SMTP server. Preview an email blast by sending a message to yourself to confirm the SMTP setting works.
To email with a FROM address of another account, make sure that email account delegated (shared) itself to the account you authenticated with in step 4 above. See this Google Delegate page for details.
Google may cause your authorization token to expire. The length of time depends on your Google account type and terms, so you may be forced to refresh this from time to time. Total Access Emailer verifies your Google Gmail settings are valid before launching an email blast and while it's sending emails.
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
"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