Send personalized Microsoft Access emails with data and reports using Total Access Emailer

Download the free trial version of Total Access Emailer to send emails for Microsoft Access

Setting Google Gmail as the SMTP Server for Total Access Emailer

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

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:

Set Your Gmail Account to Allow Less Secure Apps

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.

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

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

For more information, visit this Google Gmail page. This information was verified when written, but Google can change it at any time. Please let us know if it needs to be updated.

Using Gmail SMTP with Total Access Emailer

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

After entering the SMTP Settings and pressing [OK], Total Access Emailer validates the settings to see if it works. If it fails, a warning message appears describing the problem.

SMTP protocol error. 535 5.7.8 BadCredentials

This error message may appear:

This is caused by:

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.
Make sure the Mail Server Name and Port are correct. Visit this Goolge Page for details.
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.

Setting Google Gmail as the SMTP Server for Total Access Emailer

Additional Resources

Reviews

Emailer Info

Additional Info