Basic Authentication and Emailing from Hosted Applications
Office 365 Settings to Check
With the announcement that SMTP Auth will continue to support Basic Authentication, there are a few settings in Office 365 that can still cause Basic Authentication to be disabled and cause issues with emailing from your hosted application.
All of the below settings affect security in your Office 365 tenant and should be reviewed by your IT or an IT provider independently. gotomyerp is only providing this as a guide, from what we have found to work through our testing.
Security Defaults
To use Basic Authentication with SMTP Auth, Security Defaults must be disabled. The option to enable/disable Security Defaults can be found in the Azure AD Portal. You can log into the Azure AD portal by going to
https://aad.portal.azure.com/. You will need to be logged in as an Administrator.
- Click on "Azure Active Directory"
- Click on "Properties" in the center menu pane
- Click on "Manage security defaults" in the Properties pane
Set "Enable security defaults" to "No" in the right pane that opens
Basic Authentication settings in Modern Authentication
Another option you can check to make sure Basic Authentication is enabled for SMTP Auth is under the Modern Authentication settings in the Org settings page.
- Expand "Settings" (if you do not see Settings, click on "Show All")
- Click on "Org Settings"
- In the center pane, under "Services" scroll down to "Modern authentication"
- In the fly out pane on the right, scroll down to "Authenticated SMTP" and confirm it is checked.
SMTP Auth on Individual Accounts
SMTP Auth can also be disabled at a user level. This option disables SMTP Auth completely, not just Basic Authentication, so it is a good option to check if SMTP Auth is also not working with Modern Authentication.
- Expand "Users"
- Click on "Active users"
- Click on the user you want to check
- In the fly out pane on the right under "Mail" click on "Manage email apps"
- Confirm that "Authenticated SMTP" is checked
Gmail or Google Workspaces
If you are using a gmail or google workspaces email account, you will need to check on the below before setting up your email.
- If 2FA is enabled on your email account, you must use an app password Sign in with app passwords - Google Account Help.
- If you do not have 2FA enabled, then you will need to enable Less secure apps & your Google Account - Google Account Help
On personal Gmail accounts, you may be unable to enable less secure apps. If this is the case, we would recommend setting up 2FA or looking into upgrading your application to a newer version
For Newer Applications that support OAuth or other Modern Authentication
For Older Applications that do not support OAuth or other Modern Authentication
Below are options for Sage 100 and QuickBooks versions older than 2021.
Option 1: (Recommended): Upgrade
Upgrading to a supported version (i.e. Sage 100 2021.4, QuickBooks 2022) is recommended, as this will ensure you are using the latest security protocols and authentication methods. Please check with your consultant and contact
sales@gotomyerp.com for additional information on an upgrade.
Option 2: SMTP with Basic Auth setup
QuickBooks older than 2021
In order to configure email in QuickBooks, do the following
- Login to QuickBooks --> Edit --> Preferences --> Send Forms --> ADD --> Change Email Provider to Others
- Now enter the following and click OK
- Your Email Id : This is your email address
- Server Name : This is the server name
- Port: This is your Mail Server / SMTP Port Number
- SSL/TLS : Depending on your mail server you might have to check or uncheck the option
You will be prompted for your email password when you send an email. You would enter your AppPassword here if you have MFA/2FA enabled on your account. It will save the password for that session, but once you close out of QuickBooks, you will need to reenter your password the first time you send an email.
Sage 100 2021.3 or older
- Login to Sage --> Open Library Master --> Main menu --> Company Maintenance --> Access the E-mail tab
- Now enter the following
- Address : Mail server/SMTP Address
- Port : Port number of your mail server
- SMTP Encryption : Depending on your mail server you need to select one of them
- User ID : This is generally your email address
- Domain : This could be your email domain name, or your window domain name, some mail servers do not need this field
- Password & Confirm Password : Both are your email password
Option 3: SMTP Service Setup
gotomyerp is in no way affiliated with any of the third party SMTP services mentioned below. We are providing this information as a courtesy workaround to our clients. The use of any of the mentioned SMTP services or any other SMTP service not mentioned is the sole responsibility of the customer. We would recommend consulting with your IT or an IT service provider to find out what works best for you and your organization.
You can use a third party SMTP service (i.e.
SMTP2GO,
SendGrid), as this does not require authentication to your Office 365 and is only used for sending emails.
What you need:
- Access to your domain Name Server hosting your DNS. (Usually the same as your domain registrar, but not always)
- Add CNAME/TXT SPF records to authenticate your domain
Refer to the SMTP Server Setup section below for specific instructions on each of the aforementioned services.
SMTP Service Setup
SMTP services are only meant for sending emails and are in no way tied to your Office 365 email. You will not see the sent email in your Office 365 or your sent items. The only way to track emails sent via this method is from the providers dashboard. You are not attaching these services to a specific mailbox, which allows you to send as any email address as long as it includes your domain.
The email does not need to exist in your Office 365 or any other email provider, it can be any email address as long as it ends in the verified domain name (i.e.
this_email_is_not_real@myverifieddomain.com). Be mindful of who you are allowing to use the service, as it can be abused.
Below are the basic instructions to get started and emailing from Sage 100, QuickBooks or other applications. We recommend that you or your IT explore additional settings to comply with your security policies.
The only option that will work for QuickBooks is SMTP2GO with SMTP Users option, as QuickBooks requires a username in the format of an email address and a password
SMTP2GO
- Once signed into your account got to (1)Settings > (2)Verified Senders and click on (3)Add Sender Domain and enter your domain and click (4)Continue with this domain.
- Log into your DNS hosting provider and enter the CNAME values provided. Make sure "Enable hosted SSL" is selected. Once the DNS entries have been entered, allow at least 5 minutes to pass and then click on Verify
- If verification is complete you will see a green checkmark beside each CNAME entry in SMTP2GO. If it does not verify successfully, try again in 10 minutes or confirm that the DNS entries were entered properly. Due to the large amount DNS providers we are unable to provide instructions on how they should be entered, you will need to consult your providers documentation.
Once the domain is verified, there are two options for setting up your emails. SMTP Users and IP Authentication.
SMTP Users provides more control, as you can assign user names and password to users.
IP Authentication will allow any Sage user to send email from the hosted server, and does not require a user name or password.
Setting up SMTP Users:
Under
(1)Settings, click on
(2)SMTP Users and then
(3)Add SMTP User
- Enter in your desired (1)Username, (2)Password (these are auto generated, but can be changed) and (3)Description (optional) and then click on (4)Add SMTP User.
Note: For QuickBooks you will need to enter in a username in the format of an email.
- In the Sage email preferences enter in the following information:
(1)Address: mail.smtp2go.com
(2)Port: 587 (must use this port)
(3)SMTP Encryption: TLS/STARTTLS
(4)User ID: Username created in step b
(5)Password: password created in step b
Click on Accept to save your configuration. You can also click on "Test E-mail" before saving to confirm the relay is working properly. You can use any email as long as it is belongs to your domain, the email address is not required to have a mailbox, as this is just meant for sending.
In the QuickBooks email setup Edit > Preferences > Send Forms, click add and enter in the following information.
(1)Email ID: Username created in step b (must be in an email format)
(2)Email Provider: Others
(3)Server Name: mail.smtp2go.com
(4)Port: 587 (Must be use this port)
Check (5)SSL/TLS and then click on (6)OK
When you send your first email, you will be promted for the password that you created in the step b
- Setting up IP Authentication
Before starting, you will need the public IP address of your server, please contact support@gotomyerp.com to obtain the IP Address. Please state that it is to be used for SMTP2GO IP Authentication.
NOTE: IP Authentication will not work in QuickBooks as it requires a email address as a username. - Under (1)Settings, click on (2)IP Authentication and then (3)Continue
- Click on Add IP Address
- Enter the (1)IP address that is provided by support and a (2)Description (optional).
- In the Sage email preferences enter in the following information:
(1)Address: mail.smtp2go.com
(2)Port: 587 (must use this port)
(3)SMTP Encryption: TLS/STARTTLS
Click on Accept to save your configuration. You can also click on "Test E-mail" before saving to confirm the relay is working properly. You can use any email as long as it is belongs to your domain, the email address is not required to have a mailbox, as this is just meant for sending.
SendGrid
SendGrid will only work with Sage, as you are able to provide a username other than an email. SendGrid will not work with QuickBooks.
- Go to Email Delivery, API, Marketing Service | SendGrid and create your account.
Select your DNS hosting provider. If your provider is not listed select
"Other Host (Not Listed)". Select if you would like to brand your links for your domain, additional info can be found here
How to set up link branding | Twilio (sendgrid.com). For the purpose of this guide we will select
"No". Click
"Next" once the options have been selected
- Enter your (1)domain name in the next screen and click on (2)Next
- Log into your DNS provider and enter the records provided. Wait about 5 mins and then select "I've added these records." and click on Verify.
- You should then get a screen that confirms that the domain was verified, click on "Return to Sender Authentication". You should also see a "Verified" status next to your domain name. If it does not verify successfully, try again in 10 minutes or confirm that the DNS entries were entered properly. Due to the large amount DNS providers we are unable to provide instructions on how they should be entered, you will need to consult your providers documentation.
- Once verified, click on (1)Email API > (2)Integration Guide and click on (3)Choose under SMTP Relay
- Enter a name for your (1)API key and click Create Key. You will them be presented with the API key and (2)Password will get populated with that key.
NOTE: Copy the API key and store it in a safe location, you will not be able to retrieve it afterwards.
Before selecting (3)"I've updated my settings" Next: Verify Integration, copy the API key and setup your hosted applciation.
Open the email preferences in Sage
Enter in the following information:
(1)Address: smtp.sendgrid.net
(2)Port: 587 (must use this port)
(3)SMTP Encryption: TLS/STARTTLS
(4)User ID: apikey
(5)Password: <apikey provided in the above step>
Select (3)"I've updated my settings" Next: Verify Integration in SendGrid
- In Sage email setting click on "Test E-mail" and enter in (1)From E-mail Address, (2)Subject Line for Test and (3)E-mail Addresses then click on (4)Send.
- If you do not get an error in Sage 100 on the test email, click on "Verify Integration" in SendGrid. You should then shortly see a success message.
- Click "Accept" in Sage email setting to save your email.
Related Articles
Emailing from QuickBooks, Sage, Misys and other Applications
General Guidelines gotomyerp has tight security around all incoming and outgoing traffic, and will require a request from all clients with pertinent information, to allow email traffic through the firewall. Please note that by default, ports 587 is ...
QuickBooks is unable to send emails due to network connection failure
Issue QuickBooks is unable to send emails due to network connection failure, you receive this message when trying to send a single or multiple emails in QuickBooks from File --> Send Form Why is this issue happening? This issue could have multiple ...
Can not see Sage, QuickBooks and other applications' interface after clicking on the application
Problem After you login to the application portal and click on one of the icons to launch an application nothing happens OR After you enter Sage or QuickBooks password you do not see the application interface OR You see the application minimized in ...
TLS 1.2 Compliance for Sage 100 and Sage 300
Overview Sage has announced the following: "Effective October 1, 2023, Sage servers will stop accepting communication from Sage 100 and Sage 300 product versions using Transport Layer Security (TLS) 1.0 and 1.1." This will mean that older versions of ...
QuickBooks Print or Email Size Incorrect
Problem When one or more users try to email an invoice, receipt, order or any other document from QuickBooks it has the wrong paper size, format, orientation, etc. OR When a user tries to print they see the message "Intuit Printer Library Message: ...