Overview

Whenever you want to insert the indicated information that is currently entered in the Document Properties panel, you need to insert 'DocProperty' field codes (in Word) or define 'named ranges' formulas (in Excel).

These fields and formulas are used as placeholders for data that might change in your document.

Using DocProperty field codes (in Word)

To retrieve the values from Document Properties fields, follow the next steps:

  1. Position the insertion point within your document where you want to insert the value of the system or custom property.
  2. Click the Insert tab and select Quick Parts>Field... Word displays the Field dialog box.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/734d2d1b-7861-42d1-b8c3-0eb7f09102f4/valop001.png

  1. In the list of Categories, choose Document Information.
  2. In the list of Field Names, choose DocProperty.
  3. In the Property list, choose the target property, which was mapped previously with database field using MS Office Profile.
  4. Click on OK to close the dialog box. Word inserts the value of the specified property in your document.

<aside> 💡 Tips:

Useful field code shortcuts
F9 Update selected fields
Ctrl-Shift-F9 or Ctrl-6 Convert selected field results to static text
Ctrl-F11 Lock selected fields
Ctrl-Shift-F11 Unlock selected fields
Shift-F9 Toggle field code display for selected fields
Alt-F9 Toggle field code display for document
Ctrl-F9 Insert field code braces
Alt-Shift-Date Insert DATE field