Create a Google Gmail SMTP App Password for Total Access Emailer

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.

Google SMTP server for sending emails from Microsoft AccessHistory of Google Gmail and SMTP

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 Ending Support for Less Secure Apps

Google announced that starting May 30, 2022, Less Secure Apps is 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 recommends 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.

Create a Google App Password

Fortunately, there is an alternative by creating a Google App Password to address this. An App Password is an alternative to your Gmail password that lets Total Access Emailer send emails without knowing your actual password. Google is essentially giving you secondary passwords for SMTP.

NOTE: If your Gmail account does not allow this, you can create a Google API client ID instead.
Visit Google Gmail API Account for SMTP for details.

To create an App Password, follow the steps below. Note that these instructions and screenshots were current when we created this page, but Google may change them over time. Let us know if they are inaccurate. Google offers these instructions if you want the latest details: Sign in with App Passwords

  1. Log into your Google Account
  2. If 2-Step Verification is not activated for your account, you see this. Click the [Count me in] button:
    Google 2-step-verification
    1. Add this feature to your account by clicking [Get Started] and following the prompts:
      Google 2-step-verification protection
    2. If you have problems with this, visit this Google page.
  3. Once 2-Step Verification is activated for your account, this appears:
    Google 2-step-verification protected
  4. On the left border, click on "Security":
    Google security menu
  5. Scroll down and click on "App Passwords" which should be below the row confirming 2-Step Verification is activated:
    Google App Passwords link
    1. For some Google accounts, "App passwords" is not there. It may be at the bottom of the page after clicking "2-Step Verification" and reconfirming your login.
  6. This opens a screen to add App passwords. Under the Select App combo box, choose "Other (Custom name)"
    Google App Password for Other (Custom nName)
  7. Enter "Total Access Emailer", then click the [Generate] button:
    Generate Google App Password for Total Access Emailer
  8. An App Password is created that can be used in Total Access Emailer. Copy and save that password before you press Done. It is never shown again.
    Note that you should use your clipboard to copy it. The password appears with spaces but has no spaces:
    Google App Password generated for Total Access Emailer
    While it says it's for your device, it can be used on any device and multiple devices.
  9. When you press [Done], it appears on your list of app passwords:
    List of Google App Passwords
    You can delete it to revoke it. If you forget the password, repeat the steps to create a new one. You can create multiple App Passwords.

Enter the App Password into Total Access Emailer

Open your database and launch Total Access Emailer from the Database Tools, Add-ins menu.

Click the Options button, SMTP Settings tab, and enter your Gmail address with the App Password using these settings:

  • Connection Type: TLS
  • Port: 587
  • Server: smtp.gmail.com
  • Standard options:

SMTP Settings for Google Gmail App Password

Press the [OK] button to verify the settings and save it to a table in your database.


Additional Resources

Free Product Catalog from FMS