Wise Owl mail merging supports many of the default mail merge format codes.
String Format: (MERGEFIELD Description \* "UPPER")
This format is the same as the word option. Here are some examples:
Code | Input | Result |
UPPER | Green eggs and ham | GREEN EGGS AND HAM |
LOWER | Green eggs and ham | green eggs and ham |
FIRSTCAP | Green eggs and ham | Green Eggs And Ham |
CAPS (same as above) | Green eggs and ham | Green Eggs And Ham |
Number Format: (MERGEFIELD Total_GST \# "###0.0")
This format is the same as the word option. This format uses the characters '$', '#', ',', '.', '0' to define the format of the number.
Here are some examples:
Code | Input | Result |
0,000.0 | 123 | 0,123.0 |
$00.00 | 123.456 | $123.47 |
####.# | 123.456 | 123.4 |
0## | 123.4 | 123 |
If you would like to learn more about this format or more specifically the format strings we user internally visit https://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx .
Date Format: (MERGEFIELD CreatedDate \@ "dd-mm-yy")