Automate the Install of Microsoft Office 2016 with an MSP File

Microsoft Office is probably the flagship product for Microsoft, aside from Windows itself. There are more installs of Office out there than there are installs of Windows (all versions). Microsoft Office is available for Windows, Mac OS X, iOS, and Android. Enterprises use Office to such an extent that a computer isn’t really useful without Office installed.

Deploying Office to multiple computers over the network, at the time of imaging, or after, is a made simple with the use of an unattended install file (MSP). These files are created using a tool built in to enterprise releases of Microsoft Office. Consumer builds of Office, Office 365, do not include this tool, the “Office Customization Tool.”

To run the tool, execute the Office setup.exe command with the “/admin” modifier/switch.

setup.exe /admin

If Office has been imported into MDT, the application’s property sheet contains an “Office Products” tab where the customization tool can be launched. The tool contains no wizards, just an explorer-style interface with categories to the left and individual settings to the right.

Welcome

The welcome page for the Office Customization Tool, which comes with Office 2016.

There are a dizzying array of settings that could be configured with the tool, but only a few stand out to make deployment easier across the enterprise. During any Office deployment, the product key, registered user and organization, and product activation must be considered into the process to prevent prompts for end users, and reduced product functionality.

First is the “Install location and organization name” setting under “Setup.” The default install location is fine, just enter the appropriate organization name.

Next, is the “Licensing and user interface” settings a couple of lines down. Select the appropriate licensing scheme for your organization, accept the licensing agreement, and choose the display level of “None” with the “Suppress modal” check box selected.

Licensing

Choose the correct licensing and make sure to suppress any dialog boxes that may appear during the install.

Go to the “Modify setup properties” a couple of lines down. Here, we need to add two settings that will allow Office to auto-activate and prevent setup from rebooting the computer. The two properties are called “AUTO_ACTIVATE” and “SETUP_REBOOT.” SETUP_REBOOT is simply set to “Never”, and the AUTO_ACTIVATE option is set to 1.

Modify Setup Properties

Add the two settings illustrated and their prescribed values.

Under the “Features” section, choose “Modify user settings.” This will change things for the end user experience in Office applications. The settings we’re focusing on are the “Microsoft Office 2016 \ Privacy \ Trust Center \ Disable Opt-in Wizard on First Run“, and “Microsoft Office 2016 \ First Run \ Disable First Run Movie/Disable Office First Run on application boot.” these will get rid of the annoying first-run prompts a user sees whenever they open Office for the first time. Who actually a thought a movie would be what a user wants to see the first time they run Word?

Disable First Run Settings

Turn off all of the annoying first-run things that Office throws at the user.

Next, choose the option underneath “Set feature installation states.” This is where Office would ask what components should be installed. The computers I administer are in public locations, like classrooms, so Microsoft Outlook is not needed.

Office Features

Choose what you do not want installed with Office.

The last thing I do is create desktop shortcuts for Office applications. Choose the “Configure shortcuts” option under the “Additional options” section. Click the “Add” button to create a new shortcut. Choose the desired application for the “Target:” value. Choose the value “[DesktopFolder]” for the “Location:” property. One thing that must be done or this will not work is to add an open bracket “[” to the “Start in:” field. If this is not done, an error stating the start in folder is invalid will appear.

Desktop Shortcut

Create new desktop shortcuts the users should have for their Office applications.

We’re done! Now, the settings must be saved into an MSP file and placed in the “updates” directory of the Office installer. Choose “File” \ “Save as” from the menu at the top and choose a name for the MSP file. Microsoft recommends placing the numeral “0” at the front of the file’s name to guarantee it is the first to be read when Office is installed. Save the file in the updates folder of the Office installation directory. Now, each time setup.exe is run from that Office media, the setup parameters selected will be applied.

Enjoy!

Jason Watkins

11/3/15

 

12 thoughts on “Automate the Install of Microsoft Office 2016 with an MSP File

  1. When I save the .msp file, I notice an .xml file of the same name is also created. What am I supposed to do with this .xml file? Is it necessary in any way?

  2. Nothing but additional work and trouble !!! Tech should be easy not harder and how is that helping user who dont understand crappy C2R installer ? C2R put him self in protected mode after install and run every time when win runs and wants to have 24/day access to internet – Why ? What is it doing then ?

    • Did you read the entire post? The methods described therein are meant to install MS Office 2016 onto a copy of Windows which will be turned into an operating system image for mass-distribution. The main principle behind such is the deployment of a complete Windows install which would be immediately ready for the end user after deployment. BYOD is not a factor in this design. As soon as user is ready to use one of my PC’s, everything must be already in place. As convenient as C2R deployments can be, they’re not what’s needed here. If a user wants Office on their own device, one I do not support, and providing the license allows for it, they can Click-to-run at their discretion. Clicking through a few options in a dialog box and creating an unattend file is not a terribly intense process anyway.

  3. Hi,
    I followed exactly as above to customize office2016 and created Application Install in my task sequence in SCCM 2016. It downloads office to CCMCache folder on client machine but during the TS build, it hangs on Office installation.

    Any suggestion Jason

    • Hi,
      I have little experience with SCCM. However, there are many tutorials online which detail how to install Office 2016 with SCCM. I’d check out YouTube, and Microsoft’s own documentation.

  4. Hola Jason, excelente tutorial, me ha gustado mucho, pero te tengo una pregunta… y que pena la inocencia de la pregunta, pero a cual archivo debo colocarle el 0 adelante?, y puedo enviar desde sccm el instalador y el hace todo el proceso de acuerdo a lo configurado?

    • Hola,
      Gracias. No he trabajado con SCCM en ninguna capacidad. Sé que SCCM puede usar MDT para implementar imágenes, pero eso es todo. Uso MDT solo y, a veces, junto con MS SQL Server Express para automatizar la implementación de cientos de imágenes simultáneamente.
      ¡Gracias!

Leave a Reply

Your email address will not be published. Required fields are marked *