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.
By default, Gmail does not allow relay for your account. To activate it, log into your Gmail account to update your settings.
Under My Account, Sign-in & security, select "Connected apps & sites":
In the "Connected apps & sites" section, set "Allow less secure apps" to ON (blue):
You will receive an email verifying that you've changed this setting.
Setting Gmail SMTP Settings in Total Access Emailer
Create a text file called Temail.txt in the folder where Total Access Emailer is installed (or the location of the Total Access Emailer library if calling it through VBA). Put the name of the gmail email address in that file. This step will be eliminated in a future update of Total Access Emailer.
This error message may appear:
This is caused by:
New X.7 Versions for Microsoft Access 2013, 2010, and 2007!
X.6 Versions for Microsoft 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."
Microsoft Access MVP