Schedule and automate SQL queries | AutoSQL
DOWNLOAD

SETTINGS FOR OFFICE 365 AND GMAIL

Use These Defaults

Email settings for Office 365

If you host your email in the cloud with Microsoft, you need to connect AutoSQL to it to be able to send mail. I regularly get questions on the settings. These should be as follows:

  • Server: smtp.office365.com
  • Port:587
  • Use SSL: Yes, enabled
  • User: Your email address
  • Password: Your email password

So your AutoSQL configuration should look like:

Ofice 365 mail settings

Be aware that with sending emails, your ‘From’ address should always be your own email address. Otherwise you get the error ‘Client does not have permissions to send as this sender’:

Ofice 365 mail settings

Email settings for Gmail

The settings for Google’s Gmail should be as follows:

  • Server: smtp.gmail.com
  • Port:587
  • Use SSL: Yes, enabled
  • User: Your email address
  • Password: Your email password, please see the section below if you use 2-step verification for your account
Ofice 365 mail settings

When using 2-step verification in Google

If you use 2-step verification for your Google account, you need to create an app password in order to login to the GMail SMTP server. More info can be found on Google Support: https://support.google.com/accounts/answer/185833?hl=en