Can I set a character limit in mail merge?

Yes, it is possible to use a character limit with mail merge. There are two different functions you can use to limit characters. They are described below.

SubString()

{SubString([Column]; 0; 25)}, 0 is the starting point and 25 is the number of characters. This function limits the number of characters being displayed.

Example:

The [Notes] column contains text "testing JM character limits with functions SubString and LimitText"

Result:

LimitText()

{LimitText([Column]; 25)}, 25 is the number of characters. This function will crop text to approximate characters length without word cut-off.

Example:

Result: