Wise Owl mail merging supports many of the default mail merge format codes.
These switches and format codes should only be used if you have had experience with mail merge in Microsoft Word. Editing the switches can cause inconsistencies within your Document templates
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 number format strings we use internally visit https://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx .
...
This format string type is the same as word. Here are some examples:
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 |
Once again if you would like to learn more about date format strings we use internally visit https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx .
...
The first way involves a single letter code for the main fields:
Code | Field |
T | Title |
F | FirstName |
O | OtherNames |
L | LastName |
K | (KnownAs) |
A | Address (single line format) |
For this list there are some rules with how the fields are displayed:
...
Here are some examples of the use of the first contact format type:
Code | Result |
TFLK | Mr John Smith (J. Smith) |
| TFLK | Fish and Chips Co (F. and C. Co) |
TFOLKA | Mr John Adam Smith (J. Smith) of 123 Tree St NSW |
LF | Smith, John |
The second way of listing contacts is using a single tag from this list:
Code | Field |
Fn | FirstName |
Ln | LastName |
On | OtherNames |
Cn | CompanyName |
Ti | Title |
Ka | KnownAs |
Bn | BillingName |
Ta | TradingAs |
Lg | LegalName |
Ad | Address (as as A) |
A1 | Address alternate formatting |
If you use a second tag the template will not be valid.