Can I set a character limit in mail merge?

Yes, it's possible to set a character limit while using mail merge in JungleMail for Office 365. There are three ways to do this.

Option 1: Dynamic placeholder

1. Select the Dynamic Block, then select Columns in the block editor. 

2. Select the SharePoint column wit recipient email addresses, then select Crop text to approximate characters length without word cut-off in the drop-down menu.

3. Click Insert.

Option 2: SubString

{SubString([Column]; 0; 25)} - 0 here 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 the text "testing JM character limits with functions SubString and LimitText"

Result when using SubString:

Option 3: LimitText

{LimitText([Column]; 25)} - 25 here is the number of characters. This function will crop the text to approximately match the character length given by you, without word cut-off.

Example

Result when using LimitText

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.