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.
To retrieve the values from Document Properties fields, follow the next steps:
Position the insertion point within your document where you want to insert the value of the system or custom property.
Click the Insert tab and under the section text select Quick Parts → Field...
The Field Windows is shown.
In the list of Categories, choose Document Information.
In the list of Field Names, choose DocProperty.
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).
Click on OK to close the dialog box. Word inserts the value of the specified property in your document.
<aside> ⚠️ Please note:
Your code string should look similar to the following one: {DOCPROPERTY PropertyName \* MERGEFORMAT}, where PropertyName is name of the property the value of which you are going to retrieve.
Tip:
You can copy the PropertyName from the office profile
</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 |
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.