PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A setup page where you upload and manage the Word and Excel templates that power the Open in Microsoft Office options.
What you do here
Use this page to add templates so that users can create documents, such as Export to Word documents, from the record they are working on.
Example
For example, a Word template built for customers can be uploaded here, and users can then create a document that contains the data of the selected customer.
The page in Dynamics 365. page title tab to open what to set or check
About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.
Step by step, with screenshots
Set up Document templates1 screen
Use this page to add templates so that users can create documents, such as Export to Word documents, from the record they are working on.
Screen 1
Check a document template
Go to Organization administration > Setup > Office integration > Document templates
Find the template in the list
Check its type, root data entity and display name
Select Download to open the template, or New to upload your own
1Template name
CustInvoiceJournalTemplate
Template type
Excel
Root data entity
CustInvoiceJournalHeaderEntity
Template display name
Invoice journal line
Defined by
System
Show the full screen page title tab to open what to set or check
Steps from Microsoft
Go to Organization administration > Setup > Office integration > Document templates.
Select New.
Select Browse.
Select the template you created, and then select Open. The root data entity is read from the template.
Select OK.
Check that the template now appears in the list.
If the template shouldn't be filtered to the user's current record, clear the Apply current record filter checkbox.
Keep Apply current record filter for Export to Word documents about one record; clear it for Excel list templates that should load all recordsWith the filter on, the generated document is limited to the record the user is on; Microsoft's tutorial clears it for an Excel list template so the full list loads.
Uploading a template whose root data entity doesn't share the page's root data source. Templates are offered under Open in Microsoft Office only on pages with the same root data source.
Solution architect
5Design impact
Can it be undone
Reversible: Change, replace or remove templates at any time; documents already generated aren't changed. Reload system templates restores templates registered in code. Microsoft Learn
Technical architect
6Technical
Menu item
DocuTemplateChecked in Dynamics 365
Form
DocuTemplateChecked in Dynamics 365
Table
DocuTemplateShown as “Document templates” in Record infoChecked in Dynamics 365
Who can open it
PrivilegesMaintain document templates DocuTemplateMaintainDutiesMaintain document templates DocuTemplateMaintainChecked in Dynamics 365
Roles to set it up and use it
To set it up or change itMaintain document templates DocuTemplateMaintainGive people a role that holds these duties. On this system, 0 roles give access to this page.Checked in Dynamics 365
Actions on the page
Options: Personalize, Page options, ShareChecked in Dynamics 365
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page, the demo records and the values in the screenshots.