Setting Google Gmail as the SMTP Server for Total Access Emailer

Google SMTP server for sending emails from Microsoft AccessTotal 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.

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.

The information on this page is outdated and kept for archival purposes.

Starting June 2022, Google no longer supports Less Secure Apps for SMTP.

You need to create one of these instead:

By default, Gmail does not allow relay for your account. To activate it, log into your Gmail account to update your settings to allow less secure apps.

  1. When logged into your gmail.com account, click on your account icon in the top left and select "Manage your Google Account":
    Manage your Google Account
  2. Select Security from the left menu:
    Google Account Security
  3. Scroll down to the section for "Less secure app access" and turn it on if it is off:
    Turn on Less secure app access
  4. Once set, it should look like this:
    Less secure app access turned on

You will receive an email verifying that you've changed this setting. It may take an hour for this change to take effect.

You can connect via SSL or TLS. Details from this Google resource. Here are example using SSL (port 465) and TLS (port 587):

  • Connection Type: SSL or TLS
  • Port: 465 or 587
  • Mail Server Name: smtp.gmail.com
  • Logon: your gmail account (myname@gmail.com) and password

Using smtp.gmail.com with SSL
Setting Gmail SMTP Settings for SSL in Total Access Emailer

Using smtp.gmail.com with TLS
Setting Gmail SMTP Settings for TLS in Total Access Emailer

This error message may appear:

SMTP protocol error. 535 5.7.8 https://support.google.com/mail/?p=BadCredentials

This is caused by:

  1. The logon name (email address) and password are not valid. Make sure your values let you get into that email account. Maybe the password changed recently.
  2. Make sure the Mail Server Name and Port are correct. Visit this Goolge Page for details.
  3. The logon name is not authorized to relay messages. Your logon credentials may be correct, but the email account is not authorized to relay messages through the SMTP server. Make sure the Gmail account is set to Allow less secure apps as described above.

Additional Resources

Free Product Catalog from FMS