I found a solution that fixes my Exchange Server connection in macOS Sierra mail. Actually, this solution was mentioned earlier in this thread by “david.sinning” who posted a link to a workaround. I just could not understand how to implement the solution until now.
My Solution
First you need to know what the Exchange Server name and path is for both the internal and external connections. I was able to locate this information from another Mac that was still running El Capitan as follows:
Mail -> Preferences -> Accounts -> My Exchange Account -> Account information
Internal Server: webmail.mycompany.com
External Server: oa.mycompany.com
Mail -> Preferences -> Accounts -> My Exchange Account -> Advanced
Internal Server Path: /EWS/Exchange.asmx
External Server Path: /EWS/Exchange.asmx
Return to your macOS Sierra Mac mail application and delete the non-functioning Exchange Server account.
Add a new Exchange Server account as follows:
Mail -> Preferences -> Accounts -> select plus button “+”
For account provider select “Exchange” and click “Continue”
This gives you a box with the following fields:
Name: Jim
Email Address: Jim
Password: Jim
Just put something like “Jim” into each field and click “Sign In”
You get a box that allows you to input most of your settings manually:
Email Address: jim.cook@mycompany.com
User Name: jcook
Password: ******
Internal URL: https://webmail.mycompany.com/EWS/Exchange.asmx
External URL: https://oa.mycompany.com/EWS/Exchange.asmx
Click “Sign In”
The above should have successfully created me a functioning Exchange Server account, but it did not!
The twist for me in macOS Sierra mail was I needed to use the External URL information for both the Internal and External URL fields.
Email Address: jim.cook@mycompany.com
User Name: jcook
Password: ******
Internal URL: https://oa.mycompany.com/EWS/Exchange.asmx
External URL: https://oa.mycompany.com/EWS/Exchange.asmx
This is what actually worked in my case.
One big note of caution. I found that you cannot edit and correct the settings of an existing Exchange Server account. You must start over from scratch. Every time I tried to correct the settings of an existing Exchange Server account it would only briefly work. macOS Sierra would then quickly query Exchange Server and change the account setup causing it to fail.
This whole issue is probably being caused by new changes in macOS Sierra along with my company not keeping their Exchange Server up to date.