Office 365 installation tips and scripts

Hi all, if your like my self and many of my customers you’ve had issues moving from on premises Office installations – that use a MAK or KMS keys.

Seems when you think you’ve removed previous Office versions, and then login to Office365 and download then install the O365 installation you run into errors stating you still have previous versions of Office installed.

The solution is to FIRST completely remove ANY previous Office installations.

If you just use the ‘Program and Features’ control panel applet you are likely to still have remnants left.

To resolve this you can run the appropriate script s below and choose ‘ALL’ or whatever you feel is good enough.

[note: I have added the extension ‘.txt’ to these vbscript files. You need to remove that and leave the extension just ‘.vbs’ to run]

Here is a 7zip archive with all the scripts from Office 2007 to Office 365

Fix Microsoft Outlook – Exchange Is Unavailable, Outlook Must Be Online Or Connected

While setting up a few new users I was getting an error while trying to add a new email account.
While walking through the default setup – simply launching Outlook on a new users profile (who, of course, has and email account associated with his AD account) Outlook gave an error message that said, "The connection to Microsoft Exchange is unavailable. Outlook must be online or connected to complete this action."

IMG_1981Capture1 - redone

Now, I know that I’m online on the domain – the new user authenticated. AND I could ping the Exchange server via name too. Also since there are other users on this device and it’s fairly new I was pretty sure that it’s not a system error.

It finally seemed that the user (PC) was not able to see our domain controller as the global catalog server and hence was not able to find our mail server via Active Directory. [Why this was happening on only this user will have to be further investigated Smile ]

Per MS – This behavior occurs when the Exchange Server computer (where the Outlook client is homed) and the global catalog server are both located in a site that is remote from the Outlook client location. (article here).

The fix:

  1. Click Start, and then click Run.
  2. In the Open box, type regedit.exe, and then click OK.
  3. Locate and then click the following key in the registry:

    HKEY_CURRENT_USER\Software\Microsoft\Exchange\Exchange Provider
    Note You may have to create the registry path.

  4. On the Edit menu, click Add Value, and then add the following registry value:

    Value name: DS Server
    Data type: REG_SZ (string)
    Value data: FQDN of the global catalog server ( ourDC.domain.local )

Restart the PC and you should be able to reopen Microsoft Outlook and run through your profile set up. If finding the global catalog server was the issue, the problem should now be resolved and the email account should now properly add properly.

Capture3

     

Moving Outlook files and Settings to New computer and error (0x8004010F) : ‘Outlook data file cannot be accessed

So after setting up new PC I’ve been going through some things that might help some others.

I needed to transfer my Outlook profile to my new machine. AND I didn’t want to have to create all my connection settings over again. Yes I know I could just copy over my .pst file over to the new machine and then re-create all my accounts and point them to that .pst file. But I have a lot of accounts with unusual configurations (on the advanced connections tab) and I didn’t want to hassle with that for each and everyone of my accounts. [ I have 5 POP3 Gmail accounts I keep separated for various reasons and another 6 personal domain accounts]
So to move my Outlook file and settings I did the ‘usual’.

First, obviously, I installed MS Office (2010) on the new PC. [BUT do not launch the program yet!] I then copied over my Current Outlook folder Located here:

Win 7 and Win Vista  (drive):\Users\user\AppData\Local\Microsoft\Outlook

Windows XP (drive):\Documents and Settings\user\Local Settings\Application Data\Microsoft\Outlook

to a ‘temporary’ folder on the new PC.

I will then copy that folder to the new proper location after I import the Profile settings, as described below. First I exported the old settings and them copied them over to the new machine and imported them.

To export the profile settings (registry) from my original machine:
In Microsoft Outlook you can easily export some types of information to a file. However, there is no option to export your profile e.g. when you want to have the same settings on another computer and you do not want to manually put all of them together with the account details again. In order to do so, you can use the Windows Registry Editor that gives access to all the information.

  • Click Start
  • In the search field type Regedit and hit Enter
  • Expand the following registry entry: HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles.
  • You will see a list of your profiles.
  • Right click on the profile that you want to copy and click Export

321

  1. Then, you can specify the name of the registry file and the location to save it e.g. Desktop.
  2. Now, you need to copy the file to another computer and double click it there and choose to ‘add the information to registry’
  3. Confirm that you want to make changes to the registry.
  4. Now launch Outlook on the new machine and you will most likely get an error saying the .pst file was not found. NO big deal yet. OK/Close your way through the next few windows to EXIT the application. Here we’re only trying to create the default folder/location.
  5. Now copy the contents of the old Outlook folder from where every you had it temporarily to the new Outlook location. (path should be close to the same as above.)
  6. Now run your Outlook, the new profile will be opened (if you have only one) or you will be prompted to choose one of profiles (if you have more than one). And it ‘should’ work. At the minimum you should see all of your old mail, folders, contacts and calendars.

However I had some errors. Specifically:

Receiving reported error (0x8004010F) : ‘Outlook data file cannot be accessed.’
Sending reported error (0x8004010F) : ‘Outlook data file cannot be accessed.’

Arghh. So here is the fix that worked for me. Seems that the ‘Folder Location’ for the deliver of email was not properly ‘pathed’. Here is how to fix that.

Changing the folder to specify inbox fixed the issue. Apparently the inbox did not get set and the higher level file name was selected.

1. From Outlook 2010 click File>Account Settings>Account Settings (if you have more that one account you will have to do this for each one – just highlight/select them)

image

2. Click Change Folder (Down on the lower left corner)

2

3. Click the + to the left of the folder name to expand the subfolders. Click on ‘New Folder’ and create a new ‘temp’ folder; call it 01 or what ever, and select it. Click OK then you should now see a Folder location in the ‘Change Folder button on the lower left.

4. Now let’s go back Click on Change Folder and now Select the ‘Inbox’ instead of that ‘01’ folder and click OK. The change should now ‘stick’ for you. Click Inbox.
Click OK.

image

image

5. Close Account Settings and click send/receive. And you should be good to go.

It’s an obvious bug that the settings won’t ‘stick’. But this works!

Hope that helps some. I’m sure I’ll be referring back to it.

Fix hyperlink issues in Outlook Word and other documents and files.

If you are experiencing an issue “Can’t follow links in email “this operation has been cancelled due to restrictions in effect on this computer” error. Or getting the same error in other Office documents, then this should resolve it.

I’ve had a few clients who have had the same problem recently. Two small offices and a larger organization.

It seems they all had one thing in common. The users had recently installed and Chrome recently. And then finding this Browser was unintentionally (or secretively) installed they proceeded to uninstall/remove it. For the small office/home user this problems occurs very often. Most users have to be able to install applications. For the larger organizations this is a failure of the IT department (or their companies SOP and Policies) to properly restrict usage rights in their Active Directory GPOs

This ‘unintended’ install comes from one of my MAJOR pet peeves – software installing other non-essential and unwanted software. I believe this practice of getting unsuspecting or unaware users to install something they did not want or need by tricking them in to ‘just clicking through’ and installation of a needed or required application, plug-in or extension is downright fraudulent. Adobe is one of the worst offenders. When you update your ‘Flash Player or Shockwave Player’ they will usually try and slip in Google Chrome, McAfee or Norton Antivirus applications. And when they install those they are then set as ‘default programs’! All of which can lead to problems of usability and stability. I could go on this rant for a while but just please be warned read carefully what you are agreeing to install when you choose to update your programs/plug-ins. Make sure you ‘un-check’ any other crapware other than the actual application you are actually looking for. Okay, enough about that.

Fix for hyperlinks in email and documents:
You will need to open the registry (Go to Start type in regedit then on the found file right-click and choose ‘run as administrator) then navicate to and change the following keys from “Chromehtml” to “htmlfile”.


Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Classes\.htm]
@=”htmlfile”

[HKEY_CURRENT_USER\Software\Classes\.html]
@=”htmlfile”

[HKEY_CURRENT_USER\Software\Classes\.shtml]
@=”htmlfile”

[HKEY_CURRENT_USER\Software\Classes\.xhtml]
@=”htmlfile”

[HKEY_CURRENT_USER\Software\Classes\.xht]
@=”htmlfile”

[HKEY_CLASSES_ROOT\ftp\shell\open\command]
@=”\”C:\\Program Files\\Internet Explorer\\IEXPLORE.EXE\” %1″

[HKEY_CLASSES_ROOT\http\shell\open\command]
@=”\”C:\\Program Files\\Internet Explorer\\IEXPLORE.EXE\” %1″

[HKEY_CLASSES_ROOT\https\shell\open\command]
@=”\”C:\\Program Files\\Internet Explorer\\IEXPLORE.EXE\” %1″

Note you can also take the above and create a registry batch file.
Just copy the registry information (between the –) and save as a .reg file. That can then be launched and added to your registry.

This registry batch file can also be used to change the HKCU registry entries via Logon Script in Group Policy.
Create Registry.bat file with text:
systemroot%\regedit /s Registry.reg

Open Group Policy object, go to User Configuration > Windows Settings > Scripts > Logon
Click on Show Files (this opens a folder in \\domain-name\SysVol\domain-name\Policies\… ) and copy both files you created to that folder.
Click on Add and select Registry.bat
Deploy Group Policy object where required.

Well I hope that helps some.

Microsoft Windows 7 and Office Deals

Once again Microsoft is offering a super deal on their desktop Operating System Windows 7.  It’s called the Windows 7 Family Pack. It will be available on October 3rd in the U.S. and soon afterward in the rest of the world.

Windows 7 Family Pack gives you three (3) upgrade licenses of Windows 7 Home Premium for the low price of only $149.99. Here is some more information.

Now if you have or have access to a ‘.edu’ address, those associated with institutions of high learning, you can get some deals that are even more incredible.

Right now you can get an electronic software download of Windows 7 Professional for only$29.99 with a .edu address!! Windows 7 Pro Student Upgrade.

AND you can get Office Ultimate (with a valid .edu email address) for only $79.99!! Office Ultimate Steal.

Also take note if you purchased, installed, and activated a qualifying Microsoft Office 2007 product between March 5, 2010, and September 30, 2010, you are eligible to download Office 2010 at no additional cost. Office Tech Upgrade guarantee.

Some of my previous Windows 7 tips which may be helpful.

How to create a bootable upgrade or installation USB thumb drive to install Windows 7

All kinds of Windows 7 info

You can download the 90 day trial/demo and give Window 7 a spin too.

Then

Upgrade Windows 7 from Release Candidate or RTM version