Mail merge formulas
Mail merge formulas are used to perform calculations and manipulate data in a mail merge document. Here are some common mail merge formulas:
&: Concatenation operator - used to combine two or more text strings.
Example: Hello,&`&John&!` will output "Hello, John!"
+: Addition operator - used to add two or more numbers.
Example: The total is&10+5&. will output "The total is 15."
-: Subtraction operator - used to subtract one number from another.
Example: The difference is&10-5&. will output "The difference is 5."
*: Multiplication operator - used to multiply two or more numbers.
Example: The product is&2*3&. will output "The product is 6."
/: Division operator - used to divide one number by another.
Example: The quotient is&10/2&. will output "The quotient is 5."
^: Exponentiation operator - used to raise one number to the power of another.
Example: The result is&2^3&. will output "The result is 8."
ROUND(): Rounds a number to a specified number of decimal places.
Example: The rounded value is&ROUND(3.14159, 2)&. will output "The rounded value is 3.14."
LEN(): Returns the length of a text string.
Example: The length of the string is&LEN("Hello")&. will output "The length of the string is 5."
UPPER(): Converts a text string to uppercase.
Example: The uppercase string is&UPPER("hello")&. will output "The uppercase string is HELLO."
LOWER(): Converts a text string to lowercase.
Example: The lowercase string is&LOWER("HELLO")&. will output "The lowercase string is hello."
LEFT(): Returns a specified number of characters from the left side of a text string.
Example: The left 3 characters are&LEFT("Hello", 3)&. will output "The left 3 characters are Hel".
RIGHT(): Returns a specified number of characters from the right side of a text string.
Example: The right 3 characters are&RIGHT("Hello", 3)&. will output "The right 3 characters are lo".
MID(): Returns a specified number of characters from the middle of a text string.
Example: The middle 3 characters are&MID("Hello", 2, 3)&. will output "The middle 3 characters are llo".
IF(): Tests a condition and returns one value if true and another value if false.
Example: The result is&IF(1>2, "True", "False")&. will output "The result is False".
DATE(): Returns the current date.
Example: The current date is&DATE()&. will output the current date.
TIME(): Returns the current time.
Example: The current time is&TIME()&. will output the current time.
NOW(): Returns the current date and time.
Example: The current date and time is&NOW()&. will output the current date and time.
These are just a few examples of the many mail merge formulas available. You can use these formulas to perform a wide range of calculations and manipulations in your mail merge documents.