SETTINGS FOR OFFICE 365 AND GMAIL

Email settings for Office 365

AutoSQL has adopted Microsofts recommended OAuth2 autentication by asking the user for consent and storing the received token encrypted as part of the action list.

If you select ‘Office 365’ in the email setting, you can click the button ‘Get token’:

After you login with your Microsoft account, you will be asked to consent with the permissions needed for AutoSQL:

After finishing, it should show your username and the status ‘Active’.

If the token is not used for 90 days, or authoristation is revoked because of changes in your account, this process needs to be done again.

AutoSQL requires the following scopes to send mail on the users behalf:

• https://outlook.office.com/SMTP.Send
• offline_access

If you still want to login with a username and password, you need the details below. However, Microsoft will stop supporting this in the near future.

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

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

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