(Dansk version)


Overview

Whenever you want to insert information from Document Properties, 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 documents.

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 under the section text select Quick Parts → Field...

    image.png

  3. The Field Windows is shown.

  4. In the list of Categories, choose Document Information.

    image.png

  5. In the list of Field Names, choose DocProperty.

  6. In the Property list, choose the target property, which is mapped to the database field, created by using MS Office Profile (See How To create office profiles).

  7. Click on OK to close the dialog box. Word inserts the value of the specified property in your document.

<aside> ⚠️ Please note:

</aside>

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

Using Range Name formulas (in Excel merge)

Much like you would create data markers in your Word documents, you can do the same thing using range name feature in Excel worksheet. Excel allows you to apply a name to an individual cell or a group of cells.