SOLVED: How To Silently Install the Junk Mail Reporting Tool Using Scripts

If you have tried to install the Junk Mail reporting tool using a tool like PDQ Deploy or straight  … .MSI /q you likely have found that it errors out.  If you check the logs you will see: Product: Microsoft Junk E-mail Reporting Add-in — The installation is unable to proceed due to missing dependencies. Please verify you have all the pre-requisites installed on your machine. The installation is unable to proceed due to missing…

SOLVED: How To Insert Video Into PowerPoint or Word 2010

It can appear that changes to Word and PowerPoint are few and far between, but there was some serious improvements made to handling embedded videos in Office 2013.  If you have Office 2007 or Office 2010 you will find inserting videos to be… not obvious. Fortunately there is an easy way to insert a video into Office 2010 products without using add-ins: Start Word, Excel or PowerPoint 2007 or 2010 Click the INSERT tab Click…

SOLVED: How To Reset The Outlook Address Cache

If you are typing email addresses into your Outlook and they have gone wonky there are several things you can do but the easiest is likely just to flush the Outlook Address autocomplete cache.  In old versions of Outlook, that meant deleting the .NK2 file from %appdata%\Microsoft\Outlook however in Outlook 2016 (actually since Outlook 2010) your ‘nickname’ cache is stored in %localappdata%\Microsoft\Outlook\RoamCache There are three easy ways to empty the Outlook Autocomplete Email Address Cache: Flush The…

SOLVED: Word 2016 Grammar Checker Doing Too Much

If you are finding that the ‘grammar check’ in Office products (Word, Outlook…) are pointing out more than you would like, you can adjust it.  The latest version of Office 2016 offers two Grammar settings: GRAMMER Typical grammar checking GRAMMER AND MORE Typical grammar + things like “Wordiness” and “Vague Adjectives” You can easily toggle between the two options or even set your own grammar checking details by: Start WORD Click FILE > OPTIONS >…

SOLVED: GPO To Set Outlook To Reply In Separate Window Instead of in the Reading Pane

One of the features Microsoft introduced into Outlook is to reply in the READING PANE rather than in a separate window.  While I appreciate that this cleans up the interface, it does make navigating into old messages while composing new messages, quite messy. In the Online version Outlook Web App OWA, you can fix this by clicking the POP OUT icon.  The question is, in the desktop version, how can Outlook be set to use…

SOLVED: How To Change Office365 From Deferred to Current Channel

If you have Office365 Office 2016, by default you are running a product that is 4 months old.  This is called the Deferred Channel.  For a variety of good reasons you may want to change to the Current Channel: Testing Needing a new feature Needing to eliminate a bug that has been fixed You just like to live on the edge, like us at URTech.ca 🙂 To do this you have 3 changes to make;…

SOLVED: Office365 Office 2016 Not Changing From Deferred to Current Channel

Office 2016 from Office365 will stay in the “Channel” it was installed with even if you change from Deferred to Current or Current to Deferred in Office365.  There are three ways to force Office365 Office 2016 to change channels and I suggest using the third one. Uninstall and Reinstall Office Repair Office Right click on your START button and select APPS & FEATURES Scroll down to and click on MICROSOFT OFFICE 365 PROPLUS Click the…

SOLVED: Script and GPO To Disable Backstage When Saving In Office 2016

If you want to disable Backstage View when saving in Word, Excel, PowerPoint, … you can set it with a Group Policy Object (GPO), a script or manually HOW TO DISABLE OFFICE BACKSTAGE MANUALLY: To disable the Backstage View manually, just click: FILE > OPTIONS > SAVE > and check “Don’t show the Backstage when opening or saving files”.   This has to be set for each person, in every profile, on every machine.  That can be a…

SOLVED: How To Disable SHARE Button in Office 2016 Using a GPO

If you have Office 2016 and you want to block your staff from easily saving content in the cloud, you can disable the SHARE button using the following Group Policy Object (GPO): User Configuration -> Administrative Templates -> “Office Product Name” -> Disable Items in User Interface -> Custom -> Disable Commands > ENABLE and enter 26594 26594 does seem like a random number and it probably is, however, Microsoft has made it possible to…

SOLVED: Outlook Not Showing Presence Icons From Skype – Lync

If your Outlook is not showing the Presence Icons (Green, Red, Blue… squares beside names) there are several possible issues: UPDATED January 18 2017 – If you have Mitel MiCollab make sure you read items 1 & 5. 1 – REGISTRY POINTS TO SOMETHING OTHER THAN SKYPE – LYNC This was my issue.  I recently installed Mitel MiCollab software had not noticed that the presence icons in Outlook had disappeared about the same time.  The solution…

SOLVED: GPO To Block Macro’s On Local PC But Not File Shares

Macros in Word, Excel and PowerPoint used to be one of the most common attack vectors but they largely died out near 2010.  In 2016 they are being used aggressively in Crypto/Ransomware attacks and you may want to disable them.  Specifically, they are often sent in email attachments. Word / Excel / PowerPoint 2013 and 2016 block macro’s from untrusted sites but allow users to override this by clicking an ENABLE MACROS button… which they…

Video: SOLVED: How To Use Flash Fill in Excel to Separate Numbers From Text

If you have messy data that includes both numbers and letters in the same cell but want to separate the numbers from the letters, you can use Flash Fill.  Flash Fill is built into Excel 2013, 2016 and presumably every future version. Flash Fill typically populates cells automatically (like and autocorrect function) but if the pattern established in adjacent cells is odd, you might have force it, which is pretty easy. Watch our two minute…

SOLVED: How To Invert a Table In Excel (Swap The Columns and Rows)

If you want to invert (swap the columns for rows) using Excel 2007 through Excel 2016, you can use the TRANSPOSE function. In Excel, select all of the data you are interested in, right click select COPY Right click on an empty cell elsewhere in the same or a different worksheet Select PASTE SPECIAL > PASTE SPECIAL > click TRANSPOSE > click OK I have seen TRANSPOSE be greyed out a number of times when I have…

SOLVED: How Disable CONVERSATION VIEW in Office365 Webmail OWA and Outlook 2016

Conversation View was a pretty neat idea that I thought I would really like when it was released in 2013.  The idea of bringing all of the replies into a single thread in Outlook sounded great.  In practice I HATE IT because I find it much harder to find individual messages and because if you delete one message, you delete the entire thread… not cool.  So, how can I turn off Conversation View is a…

Video: SOLVED: How To Check / Release Office365 Quarantine Email Messages

If you have ever not received an email that you know was sent but did not bounce back to the sender, it might be that the backend server has marked it for deletion and put in the Quarentine.  Microsoft, and all good companies, have email filtering that saves you from the most aggressive spam.  In Microsoft Office365’s case, the default settings will block about 75% of your spam because Microsoft’s servers know that: Many others have…