Category Archives: Office

Viewing your Office 2016 Product Key from the Microsoft Office Account

Note: This article does not apply to Office 365 Professional Plus or Office 365 for Business installations, as the activation is tied to the Microsoft Account. This works with the online installations (Click and Run) for Office 2016 and 2013.

Why do we need to know this, if you already have the Product Key card? If you activated more than one installation on the same day, you will not easily be able to distinguish which installation pertains to the specific Product Key.

For example, when logged in to www.office.com/myaccount, we can see that this user activated the software on 2 PCs on the same day. Suppose one of these PCs needed to have Office 2016 re-installed? Which install should we choose?

office2016

If you have the Product Key card, you can compare that key to the key on one of these installations.

  1. From My Account, select Install from a disc.
    office2016a
  2. Expand I have a disc, and click View your product key
    office2016b
  3. You will now see the product key for this installation and compare this with the Product Key card to verify that you will be reinstalling the correct keyed version of Office 2016 on the PC.

Kudos to Richard and Ken from Junction City for the pointer to this information.

Outlook 2010 runs in Safe Mode after KB3114409

 

Microsoft released a bad patch on 9 December 2015, which caused Outlook 2010 to run only in Safe Mode. The fix for this is to uninstall the patch. Microsoft has already pulled this patch and is likely to release it again at a later time. I would suggest waiting at least a week before reinstalling this patch.

To fix this issue, perform the following steps to uninstall the bad patch.

  1. Close Outlook and All Microsoft Office Programs
  2. Open Control Panel
  3. Click on Programs. (Alternatively, you can search for View installed updates in the search bar at the top right corner of the Control Panel)

     

  4. Click on View Installed Updates

     

  5. Scroll down to the Microsoft Office 2010 section, and look for Update for Microsoft Outlook 2010 (KB3114409) 32-Bit Edition (or 64-Bit Edition).

     

     

     

  6. Click Uninstall

     

     

  7. Click the Uninstall button

     

  8. The patch will be uninstalled

     

  9. When the patch is uninstalled, click OK and close the Control Panel

 

 

How to change the criteria that Outlook 2010 and Outlook 2013 use to archive different item types

When archiving in Outlook, it is often useful to archive by the date of receipt for items. It is not a widely known fact that Outlook archives email messages by the last modified date. This is generally not an issue, unless you were performing some inbox cleaning out and moved an item from 2012 to another folder. At that point, the last modified date becomes the date of when you moved the email. So when you attempt to archive your mailbox, this item does not get archived.

The following KB article explains how you can change this default behaviour in Outlook – http://support.microsoft.com/kb/2553550

According to the KB article, by default, Microsoft Outlook 2010 and Microsoft Outlook 2013 archive different items based on the item type, as follows:

  • Email message: The received date or the last modified date and time, whichever is later.
  • Calendar item: The last modified date and time or the actual date that an appointment, event, or meeting is scheduled for, whichever is later.
  • Task: The completion date or the last modified date and time, whichever is later. Tasks that are not marked as completed are not archived. Tasks that are assigned to other users are archived only if the status is completed.
  • Note: The last modified date and time.
    Journal entry: The date when the journal entry is created or the last modified date and time, whichever is later.
  • Contact: Not archived.

To change this behaviour, you can create or modify the following registry setting.

Outlook 2010 – HKCU\Software\Microsoft\Office\14.0\Outlook\Preferences

Outlook 2013 – HKCU\Software\Microsoft\Office\15.0\Outlook\Preferences

Edit or Create a new DWORD value, ArchiveIgnoreLastModifiedTime, with a value of  1

IMPORTANT: You must restart Outlook after this change has been made.

You can now install Office 365 on Remote Desktop Services Servers (Terminal Servers) using Shared Computer Activation

When attempting to run Office 2013 Professional Plus, installed from your Office 365 subscription (P2, M, E3+), the following error message occurs.

Finally, there is some good news! Microsoft have announced that as of 1 September 2014, all Office SKUs – Office ProPlus, Project Pro, Visio Pro, can now be used on a shared device or virtual machine. This enables users on Remote Desktop Computers – ie Terminal Servers, to run an activated copy of Office without the requirements of purchasing an additional Volume License or Open License.

Kudos to Microsoft for finally making this feature available! For more information on this feature, see the official Microsoft blog post here – http://blogs.technet.com/b/uspartner_ts2team/archive/2014/09/03/office-365-shared-computer-activation.aspx

I will post a blog shortly to run through the installation process with screenshots.

Increase the maximum PST file size for Outlook

I have been working through a bunch of Microsoft Exchange migrations recently. One of the issues that we have seen has to do with the size of the exported PST file. By default, the maximum size of PST files has been limited to 20GB for Outlook 2003 and 2007, and 50GB for Outlook 2010 and 2013.

This limit can be increased or decreased via two registry settings.

  • WarnLargeFileSize – This value sets warning threshold in MB for the maximum size of a PST file. The maximum is 4090445042 (That is about 4PB!)
  • MaxLargeFileSize – This value determines the maximum size in MB that can be written to a PST file. This should be set to about 5% higher than the warning size above. This maximum is 4294967295.

Here are some common values that could be used:

  •  30GB maximum (29GB warning) = 30720 (29696)
  • 75GB (73GB) = 76800 (74752)
  • 100GB (95GB) = 102400 (97280)
  • 150GB (145GB) = 153600 (148480)
  • 200GB (190GB) = 204800 (194560)
  • 500GB (480GB) = 512000 (460800)
  • Are you sure you want such a large PST file after this?

The registry settings are found or created here, depending on the Outlook version.

  • Outlook 2003 HKCU\Software\Microsoft\Office\11.0\Outlook\PST
  • Outlook 2007 HKCU\Software\Microsoft\Office\12.0\Outlook\PST
  • Outlook 2010 HKCU\Software\Microsoft\Office\14.0\Outlook\PST
  • Outlook 2013 HKCU\Software\Microsoft\Office\15.0\Outlook\PST

Archive Outlook items by received or sent date, not by last modified date

While looking through some maintenance tasks, I came across a knowledge base article that solved a long standing issue. In Outlook 2010 and Outlook 2013, it is possible to archive items by their date received or sent instead of by the last modified date.

Microsoft KB2553550 (http://support.microsoft.com/kb/2553550) details the steps.

Outlook 2010

To create the ArchiveIgnoreLastModifiedTime registry value, follow these steps:

  1. Start Regedit.
  2. Locate and then click the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Preferences
  3. On the Edit menu, point to New, click DWORD Value, type ArchiveIgnoreLastModifiedTime, and then press ENTER.
  4. Right-click ArchiveIgnoreLastModifiedTime, and then click Modify.
  5. In the Value data box, type 1, and then click OK.
  6. Exit Registry Editor.

Outlook 2013

To create the ArchiveIgnoreLastModifiedTime registry value, follow these steps:

  1. Start Regedit.
  2. Locate and then click the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Preferences
  3. On the Edit menu, point to New, click DWORD Value, type ArchiveIgnoreLastModifiedTime, and then press ENTER.
  4. Right-click ArchiveIgnoreLastModifiedTime, and then click Modify.
  5. In the Value data box, type 1, and then click OK.
  6. Exit Registry Editor.

You must restart Outlook after you add the ArchiveIgnoreLastModifiedTime registry key.

Locating a Folder in Outlook 2013

Chances are you have suffered from a case of “sticky mouse syndrome” where the mouse apparently sticks and drags a folder while you are working in Outlook. If you have a lot of folders, it will become impossible to find this folder. The most frustrating thing is that you remember an email in that folder and search for the folder. You open the email, and see the name of the folder which holds the email, but you do not know where this folder is located in relation to the entire mailbox. How do you locate this mailbox, so that you can move it back to the right location?

  1. In Outlook 2013, search for an email in the folder you are looking for. In this example, I am looking for an email from George, because I remember that I filed his email in to the correspondence folder that I have lost.

     

  2. I open this email and confirm that it is indeed in the correspondence folder.

     

  3. Going back to the message, press CRTL-SHIFT-F to open the Advanced Find window. The containing folder will be listed

     

  4. Click the Browse button, and you will now see the exact location of this folder. It was moved under the Inbox!

 

Where is the Temporary Outlook Folder *UPDATE*

I am updating this post for Outlook 2010 and Outlook 2013.

The original post covering previous versions of outlook can be found here – http://blog.powerbiz.net.au/registry-hacks/where-is-the-temporary-outlook-folder/

For Outlook 2010, the registry location which shows the location of the Outlook Temporary Folder is HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Security.

For Outlook 2013, the registry location which shows the location of the Outlook Temporary Folder is HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Security.

How to manually configure Outlook 2010 for Office 365

Sometimes, the domain hosting company is not able to properly configure autodiscover CNAME records to enable the domain to work properly with the Office 2010 auto configuration wizard. In this case, it may be necessary to manually configure Outlook 2010 to connect to the Office 365 servers.

1. Login to the Microsoft Online Services portal at https://portal.microsoftonline.com and open up the Outlook Web App.

 

2. Note down the address of the server – ie. hkprd0402.outlook.com

 

3. Open up the Add New Account wizard (From the Mail settings in the Control Panel)

4. Select Manually configure server settings or additional server types.

 

5. Select Microsoft Exchange or compatible service.

 

6. Enter the following information. The server name is the name of the Outlook Web App server, with an extra “mailbox” added in. ie. hkprd0402.outlook.com -> hkprd0402.mailbox.outlook.com.au

Put in the user’s Office 365 email address in the User Name.

DO NOT CLICK the Check Name button yet. Instead, click on the More Settings button.

 

7. Navigate to the Connection tab, check the Connect to Microsoft Exchange using HTTP tick box and click on the Exchange Proxy Settings button.

 

8. Enter the information in as shown. Once again, use the name of the server as noted in the Outlook Web App screen.

 

9. Select OK twice, and then Click Check Name at the Add New Account screen.

 

10. A Windows Security window will appear. Type in the Office 365 credentials here.

 

11. If everything authenticates properly, the Server and Username Fields will be underlined and you can now click Next, and complete the wizard.