Osprey Academy - Customer Support & Training

Using Osprey

Learn how to use Osprey to manage your day-to-day operations and processes

Using and Formatting Fields in Word

Who is this guide for?

Case Management Supervisors

Within Osprey’s standard documents, it is possible to use standard Word fields as well as formatting these and your Osprey merge fields in the way you want to.

The most common question we are asked is why numbers or currency fields in Osprey standard documents display with 4 decimal places. Numbers are stored in the database with 4 decimal places, but you can use the number formatting switch to display these as you wish, even including the currency symbol.

When you view the MergeField field in your document, the syntax looks like this: { MERGEFIELD  Client_name }. By adding a switch, we can customise how the document displays this information.

For example, { MERGEFIELD Client_name \*Upper} will display the client name from within Osprey and display it in upper case within the Standard Document.

Number Mergefield Switches

\# £#,##.00Displays a number as £0,000.00
\*CardTextDisplays numbers as text
(for numbers over 999,999, please follow the below guide https://support.ospreyapproach.com/guides/converting-numbers-to-text-within-word/)

Number Mergefield Switches Examples

\# £#,##.00{MERGEFIELD Cost \# £#,##.00}£123,456.00
\*CardText{MERGEFIELD Cost \*CardText}One hundred

Text Mergefield Switches

\b “TEXT”Specifies the text to be inserted before the MergeField field if the field is not blank
\f “TEXT”Specifies the text to be inserted following the MergeField field if the field is not blank
\f “SHIFT + ENTER”Specifies the text to be inserted on the next line following the MergeField field if the field is not blank.
\* UpperDisplays the MergeField in uppercase

Text Mergefield Switches Examples

{ MERGEFIELD Name2 \b ” and ” }
Name 2 is present =
John and Joan
Name2 is empty =
\f “TEXT”{ MERGEFIELD HouseName \f “, “}{ MERGEFIELD HouseNum }HouseName is present = The Bridges, 34
HouseName is not present = 34
{ MERGEFIELD HouseName \f “
“}{ MERGEFIELD HouseNum \f “

“}{MERGEFIELD HouseRoad}
HouseName, HouseNum and HouseRoad are present =
The Bridges
Church Road
HouseName is not present =
Church Road
HouseName and HouseNum are not present =
Church Road
\* Upper{MERGEFIELD ClientName \*Upper}JOHN SMITH

Date & Time Mergefield Switches

{QUOTE{DATE}}Inserts the date that the document was created
\@ ” “This allows the formatting of the date
Day formatsd = Displays a single-digit day,
dd = Displays a two-digit day,
ddd = shows three letter abbreviation for day of the week
dddd = displays full name of the day of the week
Month formattingM = Displays single-digit months with no leading zero
MM = Displays single-digit months with leading zero
MMM = Displays a three-letter month abbreviation.
MMMM = Displays the full month name
Year Formattingyy = Displays a two-digit year number.
yyyy = displays a four-digit year number.
Hours Formattingh = displays single-digit hours based on 12-hour clock without a leading zero.
hh = displays Single-digit hours based on 12-hour clock with a leading zero.
H = displays single-digit hour based on 24-hour clock.
HH = displays two-digit hour based on 24-hour clock.
Minute Formattingm = Displays single-digit minutes without a leading zero
mm = Displays single-digit minutes with a leading zero
AM/PMDisplays uppercase AM or PM
am/pmDisplays lowercase am or pm

Date & Time Mergefield Switches Examples

\@ “dd MMMM yyyy”{DATE \@ “dd MMMM yyyy”}07 April 2021
\@ “HH:mm AM/PM”{MERGEFIELD Time \@ “HH:mm AM/PM”}09:34 AM
\@ “MMM-yy”{MERGEFIELD Date \@ “MMM-yy”}Mar-21
\@ “m ‘minutes'”{MERGEFIELD Time \@ “m ‘minutes'”}6 minutes


When looking to add an email field, you will need to add the merge field into the document first. Once added, highlight the relevant merge field, and navigate to Insert > Link.

On the popup window, select Email Address, and enter mailto: so it will look as below.

Once completed, select OK. A new hyperlink MailTo field will be shown within the word document.
Insert the same merge field again, this time right after the mailto: as seen below

{HYPERLINK “mailto:{EMAIL}”} {HYPERLINK “mailto:{ MERGEFIELD FEE_EARNER_EMAIL}”}support@pracctice.net

Other Field Codes

For more help and a full list of field codes available in Microsoft Word, click here: List of field codes in Word (microsoft.com)

In this article