Excel

Word Experienced an Error Trying to Open the File

10 October 2019
Dwayne Grimes
No comments
Categories: Excel, Office, Office 365, Outlook, Word

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.

You can set up Word and Excel to not block these file types from Outlook.

  • Open Word and/or Excel and click on “File“
  • Go down to “Options“.
  • Click on “Trust Center“, “Trust Center Settings” , and then “Protected View“
  • Uncheck at least “Enable Protected View for Outlook Attachments“.

Let us know if this helped you.

Export Outlook Global Address Book to Excel

6 September 2019
Dwayne Grimes
No comments
Categories: Excel, Global Address Book

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 “Data” tab 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…

Translate »