How To Fix Outlook and Office 365 Issues

image

I recently set up an Outlook 365 Business  account.  It was easy to set up and to get it going on my browser.

Then I set up the email address on my desktop Outlook 2013 Client.  It worked well for two days and then I started to get error messages:

   An unhandled win32 exception occurred in Outlook.exe [14592].

The number on the message would change from time to time when I was logging in.  Sometimes it was 14595, or 5672, or 5996.  And, using Visual Studio debugging tool did not help.

Microsoft Outlook would not open at all so I could not get into it to make changes.

I tried many things that did not work.

Here is what worked:

1. I found a site for Office Support, and it had a section on Office 365 Business Accounts.  You can find this information at https://support.office.com/en-us/article/Outlook-email-setup-6e27792a-9267-4aa4-8bb6-c84ef146101b

2. I clicked on the phrase “automatically diagnose and fix many Outlook setup issues

3. This took me to the “FIX OUTLOOK” page at https://portal.office.com/support/help.aspx?sid=sara#/330cfd4a-358a-47fc-a679-71c762039f09

4. I downloaded the Microsoft Support and Recover Assistant for Office 365, and installed it.

5. The process took about 45 minutes to run through all the possible issues. 

In the end, the RECOVER ASSISTANT did fix my client and get it to open.  And, it did tell me that my profile needed to be reset.  It is a good tool to use when you do not know what is wrong.

If you ever need to use the RECOVER ASSISTANT, let me know if it works for you.

Microsoft Office 2016 New Features Include Power BI And SQL Server Database Connector

image

Figure 1 – from technewstoday.com

Sandy Stachowiak posted a great article on 10 New Microsoft Office 2016 Features to Increase Productivity at http://www.makeuseof.com/tag/10-new-microsoft-office-2016-features-increase-productivity/.

You can read her blog in detail as she does a great job of highlighting new features.  The big features for Dynamics ERP users is the feature for NEW AND IMPROVED CONNECTION options.  Here is what she says.

Connectivity for Excel

You can import data from SAP HANA databases, SharePoint folders, and online services such as Salesforce Objects or Reports. Select Data > New Query and then make the appropriate selection from the drop-down box.

The connectors for IBM DB2 and SQL Server Database have been improved as well. For IBM DB2 you can now choose the Microsoft driver and for SQL Server Database you can include schema information as part of the navigation hierarchy.

Excel2016SQLServerNavigate

 

Connect Excel To Power BI with Publish

Power BI is a service that can transform your data into interactive reports. Using the business dashboard, you can monitor, analyze, and build models easily. Select File > Publish to upload workbooks or export workbook data directly to and from Power BI.

Excel2016PublishToPowerBI

Note that the service requires that you have a OneDrive for Business subscription.