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")
Code | Input | Result |
MMMM dd, yyyy | 17/05/16 9:00pm +10:00 | May 10, 2016 |
dd-MM-yy | 17/05/16 9:00pm +10:00 | 17-05-16 |
h:m:s dd-mm-yyy z | 4/02/15 2:00am +11:00 | 2:0:0 04-02-015 +11:00 |
hh:mm:ss dd-mm-yy z "Apple" | 17/05/16 9:25pm +10:00 | 9:25:00 17-05-16 +10:00 |