Category Archives: Office

Office365 – Incompatible Office products are installed on your machine” when opening Office.

When you try to open office documents you get ‘Incompatible Office products are installed on your machine’ error.

The solution to this error is to delete the stand-alone Microsoft OneDrive for Business 2013 sync client from add / remove a program.

Once this program is removed you can succesfully open office programs again without the error message!

Note that you may have to reinstall office365 again.

Office365 – Automatically add lync users to your lync contacts

When you have an Office 365 subscription you get access to Lync software.

If you install Lync and you want to add people to your contacts you have to manually add each user.

Currently there is no official solution to achieve an automation for this.

There is however, a workaround:

Log in to the Exchange Admin Center.
Go to ‘groups’ and create a new Distribution group.
Add every user to this group and click save.

In the Lync software you can search for the dist group you just created.
Right click the group and choose ‘Add to contact list’

You now have every user in that group as a contact!

Install Office 365 ProPlus on Windows Terminal Server / RDS

UPDATE 2017: There is now this awesome tool as where you can create an Office365 installer, see here for more information:
https://officedev.github.io/Office-IT-Pro-Deployment-Scripts/XmlEditor.html

Since September 2014, the ProPlus edition of Office 365 allows you to install Office365 on a terminal server.

This how-to will help you install Office 365 ProPlus on your terminal server.
I’ve tested this with Windows 2008 R2.

Step 1. If for example, Office 2013 is installed you need to completely remote that.
There is a FixIt for this: http://support.microsoft.com/kb/2739501

Step 2. You need to download the Office Deployment Tool here – http://www.microsoft.com/en-us/download/details.aspx?id=36778

Step 3. Run the tool and extract the files to a folder on your server.

Step 4. Edit the ‘Configuration.xml’ file.
My file looks like this:
<Configuration>

<Add OfficeClientEdition="32" >
<Product ID="O365ProPlusRetail">
<Language ID="en-us" />
</Product>
</Add>

<Display Level="None" AcceptEULA="True" />
<Property Name="SharedComputerLicensing" Value="1" />
<Logging Path="%temp%" />

</Configuration>

Step 5. Run ‘cmd’ as administrator and CD to the folder you used for extracting the files.

type: setup.exe /download configuration.xml

The Office365 files will now be downloaded.

Step 6. When that’s complete run the next command:
setup.exe /configure configuration.xml

Step 7. When this command is complete Offce365 is installed on your terminal server.

Step 8. Make sure every user that should be using Office 365 has an active license in the Office 365 control panel.
Once you start Office365 on the server the program will come up with an activation screen, log in with the users credentials and you are ready to go!

Office 365 – Become a partner of record for your customer

To become partner of record you will need your Partner ID. You can find this in the partner portal from microsoft: https://partners.microsoft.com/

When you have your Partner ID you have to log in with the customers administrator office365 account on portal.office.com.
Go to -> Billing -> subscriptions.
Select the subscription on the right, at the actions panel choose, Add partner of record.
Copy your Partner ID and click Ok.

You are now a partner of record for this customer.

Outlook – How to create pst files and move (mail) items.

To make sure your mailbox doesn’t grow too big at the mailserver a good way to save your mail items is to create a pst file.
Rather than exporting -> deleting -> and opening a .pst file which is an often used method you can more easily create a .pst file within Outlook.

Open Outlook
Choose -> New Items (Home Ribbon) -> More items -> Outlook Data File
outlook2

Now you have to select a location where you would like to store your .pst file.
outlook1

Type in a name and click Ok

You will now see your Inbox again, on the left side you will see the newly created .pst file.
In this .pst file you can create folders, and move mail items from your Inbox to this .pst file.
outook3

Connect to Office 365 using Windows Powershell

Open Windows Powershell and run the following commands:

$LiveCred = Get-Credential

Type your Office 365 administrator account and click ‘Ok’

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection

Import-PSSession $Session

Outlook – Automatically save an outlook attachment to disk

If you want to automatically save an attachment to a folder on your computer/server do the following:

Open Outlook and open Microsoft Visual Basic for Applications (Alt + F11).
Expand the tree view on the left till you reach ThisOutlookSession, now right click on ThisOutlookSession and select insert -> module.

You will now get a blank window, copy and paste this code:

Public Sub saveAttachtoDisk (itm As Outlook.MailItem)
Dim objAtt As Outlook.Attachment
Dim saveFolder As String
saveFolder = "c:\temp\"
For Each objAtt In itm.Attachments
objAtt.SaveAsFile saveFolder & "\" & objAtt.DisplayName
Set objAtt = Nothing
Next
End Sub

Change the ‘saveFolder’ to something you want.
Save and close the Visual Basic app.

Now you will need to create a rule in Outlook that launces this script when an email arrives.

Go to Tools -> Rules and alerts -> New rule and choose Check message when they arrive -> with attachment (for example) -> run a script, click script and select your newly created VB script. Click finish and sent an test email.

If nothing is happening you probably should change the macro settings in Outlook: In Outlook go to File -> Options -> Trust center -> Trust center settings -> Macro settings and select ‘Notifications for all macros’ and click Ok.

Restart Outlook, you will get a message that your newly created script is trying to make changes to Outlook, allow that and try to send a test message again!

I tested this in Outlook 2010.

Office 2010 – attachments are being blocked

When you try to open an attachment which came in a email you get the message ‘This file is damaged’ you need to do the following:

Open word / excel / powerpoint (whatever attachment you have)

# Open WORD -> file -> options -> trust center -> settings -> Protected View -> uncheck the 3 boxes.

Now restart outlook / office and try open your attachment again!