Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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")

...

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")

...

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 . 


Date Format: (MERGEFIELD CreatedDate \@ "dd-mm-yy")

...

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 . 


...

Below are the new merge field format options that we have added to our mail merge. 


Image Format: (MERGEFIELD Our_Logo \& "54") 

...

For example a number of "43" would scale an image to 43% of its normal size. 


Contact Format: (MERGEFIELD ContactsOfType_Client \^ "TFLK)

...

Note: Each contact's information is separated by the character ';' (semi colon). 


There are 2 main ways of retrieving the data from contacts.

...

Code

Result

TFLK

Mr John Smith (J. Smith)
TFLKFish 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:

...