Settings for office 365 and gmail

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:

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’:

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