Word Experienced an Error Trying to Open the File

We noticed users were having issues opening Office documents like a Word or Excel file that was sent to them via email. Everything looks normal, but when they click on the file to open it they get the following error.

The fix is really easy.

  • Save the file to your machine
  • Right-click on the file and go down to “Properties“.
  • On the General Tab, check “Unblock” and click okay. This may be on the Security tab.
  • Double-click the file to open it.

Let us know if this helped you.

Export Outlook Global Address Book to Excel

We needed to have an Excel spreadsheet of the email addresses we had in global address book group. Here is the best method we found so far.

  • Open a new email
  • In the “To” area click on the “To” button and select your group.
  • Next to the group name you will see a “+” icon. Click on this and this will display the email addresses.
  • We had a lot of email addresses so we needed to click on the “23 others” text to see all the email addresses.
  • Copy all these email addresses.
  • Open Excel and paste them into a single cell.
  • Select that single cell and go to the “Datatab in the Excel Tool Ribbon, and click on “Text to Column“.
  • Choose “Delimited” on the first prompt.
  • Choose “;” or “Semicolon” on the next prompt.
  • Choose “General” on the next, and hit “Finish“.
  • Select the whole row by clicking on the row number and hitting “CTL + C
  • Move down to a blank cell and right-click and choose “Paste Option: Transpose

Let us know if this helped you…