{"id":35488,"date":"2021-09-15T17:17:49","date_gmt":"2021-09-15T16:17:49","guid":{"rendered":"https:\/\/support.ospreyapproach.com\/?post_type=pracctice_guide&p=35488"},"modified":"2024-08-05T15:19:01","modified_gmt":"2024-08-05T14:19:01","slug":"using-and-formatting-fields-in-word","status":"publish","type":"pracctice_guide","link":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/","title":{"rendered":"Using and Formatting Fields in Word"},"content":{"rendered":"
\n\n

Who is this guide for?<\/strong><\/p>\n

<\/i> Case Management Supervisors<\/strong><\/p> \n<\/div>\n\n\n\n

This guide will take you through how to format mergefields in Microsoft Word<\/h2>\n\n\n\n

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.<\/p>\n\n\n\n

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. <\/p>\n\n\n\n

When you view the MergeField field in your document, the syntax looks like this: { MERGEFIELD<\/strong>  Client_name<\/em> }. By adding a switch, we can customise how the document displays this information.<\/p>\n\n\n\n

For example, { MERGEFIELD<\/strong> Client_name \\*Upper} will display the client name from within Osprey and display it in upper case within the Standard Document. <\/em><\/p>\n\n\n\n

<\/p>\n\n\n\n

Number Mergefield Switches<\/p>\n\n\n\n

<\/p>\n\n\n\n

\\# \u00a3#,##.00<\/td>Displays a number as \u00a30,000.00<\/td><\/tr>
\\*CardText<\/td>Displays numbers as text
(for numbers over 999,999, please follow the below guide https:\/\/support.ospreyapproach.com\/guides\/converting-numbers-to-text-within-<\/a>word<\/a>\/<\/a>)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Number Mergefield Switches Examples<\/p>\n\n\n\n

Format<\/th>Example<\/th>Output<\/th><\/tr><\/thead>
\\# \u00a3#,##.00<\/td>{MERGEFIELD Cost \\# \u00a3#,##.00}<\/td>\u00a3123,456.00<\/td><\/tr>
\\*CardText<\/td>{MERGEFIELD Cost \\*CardText}<\/td>One hundred<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Text Mergefield Switches<\/p>\n\n\n\n

\\b “TEXT”<\/td>Specifies the text to be inserted before the MergeField field if the field is not blank<\/td><\/tr>
\\f “TEXT”<\/td>Specifies the text to be inserted following the MergeField field if the field is not blank<\/td><\/tr>
\\f “SHIFT + ENTER”<\/td>Specifies the text to be inserted on the next line following the MergeField field if the field is not blank.<\/td><\/tr>
\\* Upper<\/td>Displays the MergeField in uppercase<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Text Mergefield Switches Examples<\/p>\n\n\n\n

Format<\/th>Example<\/th>Output<\/th><\/tr><\/thead>
\\b “TEXT”<\/td>{ MERGEFIELD Name1 }<\/em><\/em>
{ MERGEFIELD Name2 \\b ” and ” }<\/em><\/em><\/td>		Name 2 is present =
John and Joan
Name2 is empty =
John<\/td><\/tr>
\\f “TEXT”<\/td>{ MERGEFIELD HouseName \\f “, “}<\/em><\/em>{ MERGEFIELD HouseNum }<\/em><\/em><\/td>HouseName is present = The Bridges, 34
HouseName is not present = 34<\/td><\/tr>
\\f
“SHIFT+ ENTER”<\/td>		{ MERGEFIELD HouseName \\f “
“}{ MERGEFIELD HouseNum \\f “<\/em>
“}{MERGEFIELD HouseRoad}<\/em><\/td>		HouseName, HouseNum and HouseRoad are present =
The Bridges
34
Church Road
HouseName is not present =
34
Church Road
HouseName and HouseNum are not present =
Church Road<\/td><\/tr>
\\* Upper<\/td>{MERGEFIELD ClientName \\*Upper}<\/em><\/td>JOHN SMITH<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Date & Time Mergefield Switches<\/p>\n\n\n\n

{QUOTE{DATE}}<\/em><\/em><\/td>Inserts the date that the document was created<\/td><\/tr>
\\@ ” “<\/td>This allows the formatting of the date<\/td><\/tr>
Day formats<\/td>d = 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<\/td><\/tr>
Month formatting<\/td>M = 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<\/td><\/tr>
Year Formatting<\/td>yy = Displays a two-digit year number.
yyyy = displays a four-digit year number.<\/td><\/tr>
Hours Formatting<\/td>h = 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.<\/td><\/tr>
Minute Formatting<\/td>m = Displays single-digit minutes without a leading zero
mm = Displays single-digit minutes with a leading zero<\/td><\/tr>
AM\/PM<\/td>Displays uppercase AM or PM<\/td><\/tr>
am\/pm<\/td>Displays lowercase am or pm<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Date & Time Mergefield Switches Examples<\/p>\n\n\n\n

Format<\/th>Example<\/th>Output<\/th><\/tr><\/thead>
\\@ “dd MMMM yyyy”<\/td>{DATE \\@ “dd MMMM yyyy”}<\/em><\/td>07 April 2021<\/td><\/tr>
\\@ “HH:mm AM\/PM”<\/td>{MERGEFIELD Time \\@ “HH:mm AM\/PM”<\/em>}<\/td>09:34 AM<\/td><\/tr>
\\@ “MMM-yy”<\/td>{MERGEFIELD<\/em> Date \\@ “MMM-yy”}<\/em><\/td>Mar-21<\/td><\/tr>
\\@ “m ‘minutes'”<\/td>{MERGEFIELD<\/em> Time \\@ “m ‘minutes'”}<\/em><\/td>6 minutes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Emails<\/p>\n\n\n\n

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.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

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<\/p>\n\n\n\n

Format<\/th>Example<\/th>Output<\/th><\/tr><\/thead>
{HYPERLINK “mailto:{EMAIL}”}<\/a><\/td> {HYPERLINK “mailto:{ MERGEFIELD FEE_EARNER_EMAIL}”} <\/td>support@pracctice.net<\/a><\/td><\/tr>
<\/td><\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Other Field Codes<\/p>\n\n\n\n

For more help and a full list of field codes available in Microsoft Word, click here: List of field codes in Word (microsoft.com)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This guide will take you through how to format mergefields in Microsoft Word 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 […]<\/p>\n","protected":false},"author":30,"featured_media":0,"template":"","categories":[188],"tags":[124,125,123],"class_list":["post-35488","pracctice_guide","type-pracctice_guide","status-publish","hentry","category-supervisor-case-management-setup","tag-mergefield","tag-mergefields","tag-word-documents"],"acf":{"display_as_dashboard_announcement":false,"announcement_title":"","announcement_type":"New feature","announcement_link_text":"Learn more","announcement_image":null},"yoast_head":"\nUsing and Formatting Fields in Word | An overview of Integrations | Osprey Academy - Customer support and training centre<\/title>\n<meta name=\"description\" content=\"A how-to guide for formatting merge fields in Microsoft Word\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using and Formatting Fields in Word | An overview of Integrations | Osprey Academy - Customer support and training centre\" \/>\n<meta property=\"og:description\" content=\"A how-to guide for formatting merge fields in Microsoft Word\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/\" \/>\n<meta property=\"og:site_name\" content=\"Osprey Approach Customer Support & Training | Osprey Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/OspreyApproachUK\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-05T14:19:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@OspreyApproach\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/\",\"name\":\"Using and Formatting Fields in Word | An overview of Integrations | Osprey Academy - Customer support and training centre\",\"isPartOf\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png\",\"datePublished\":\"2021-09-15T16:17:49+00:00\",\"dateModified\":\"2024-08-05T14:19:01+00:00\",\"description\":\"A how-to guide for formatting merge fields in Microsoft Word\",\"breadcrumb\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#primaryimage\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.ospreyapproach.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guides\",\"item\":\"https:\/\/support.ospreyapproach.com\/guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Using and Formatting Fields in Word\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"name\":\"Osprey Approach Customer Support & Training | Osprey Academy\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\",\"name\":\"Osprey Approach Customer Support & Training | Osprey Academy\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"width\":201,\"height\":61,\"caption\":\"Osprey Approach Customer Support & Training | Osprey Academy\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/OspreyApproachUK\/\",\"https:\/\/x.com\/OspreyApproach\",\"https:\/\/www.linkedin.com\/company\/ospreyapproach\",\"https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using and Formatting Fields in Word | An overview of Integrations | Osprey Academy - Customer support and training centre","description":"A how-to guide for formatting merge fields in Microsoft Word","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/","og_locale":"en_GB","og_type":"article","og_title":"Using and Formatting Fields in Word | An overview of Integrations | Osprey Academy - Customer support and training centre","og_description":"A how-to guide for formatting merge fields in Microsoft Word","og_url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/","og_site_name":"Osprey Approach Customer Support & Training | Osprey Academy","article_publisher":"https:\/\/www.facebook.com\/OspreyApproachUK\/","article_modified_time":"2024-08-05T14:19:01+00:00","og_image":[{"url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@OspreyApproach","twitter_misc":{"Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/","name":"Using and Formatting Fields in Word | An overview of Integrations | Osprey Academy - Customer support and training centre","isPartOf":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#primaryimage"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#primaryimage"},"thumbnailUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png","datePublished":"2021-09-15T16:17:49+00:00","dateModified":"2024-08-05T14:19:01+00:00","description":"A how-to guide for formatting merge fields in Microsoft Word","breadcrumb":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#primaryimage","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-268.png"},{"@type":"BreadcrumbList","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/using-and-formatting-fields-in-word\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.ospreyapproach.com\/"},{"@type":"ListItem","position":2,"name":"Guides","item":"https:\/\/support.ospreyapproach.com\/guides\/"},{"@type":"ListItem","position":3,"name":"Using and Formatting Fields in Word"}]},{"@type":"WebSite","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","name":"Osprey Approach Customer Support & Training | Osprey Academy","description":"","publisher":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization","name":"Osprey Approach Customer Support & Training | Osprey Academy","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","width":201,"height":61,"caption":"Osprey Approach Customer Support & Training | Osprey Academy"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/OspreyApproachUK\/","https:\/\/x.com\/OspreyApproach","https:\/\/www.linkedin.com\/company\/ospreyapproach","https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA"]}]}},"_links":{"self":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/35488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide"}],"about":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/types\/pracctice_guide"}],"author":[{"embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/users\/30"}],"version-history":[{"count":3,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/35488\/revisions"}],"predecessor-version":[{"id":69053,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/35488\/revisions\/69053"}],"wp:attachment":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/media?parent=35488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/categories?post=35488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/tags?post=35488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}