Hi,

We're using your merge script to deliver customised training reports to users, which includes lists of courses attended. These lists are of varying lengths and are stored for each user in one excel cell, separated by newlines (ALT+ENTER in Excel). However, these newline characters, or any version thereof (\n, <br>, Char(13), Char(10), Char(13) & Char(10) etc.) are currently lost when merging to Notes. The only way I can send people a list is to comma-delimit items on the list on the same line, which is extremely difficult to read.

Please modify your great script to transmit Excel's newline characters to Notes.

Thanks in advance!

Thanks for the request Nick,

MailMerge v1.4 now includes a revised function to support new-lines (char:10 or Alt+Enter) wrapped (or added in formula) in text fields.

It is implemented by cloning the RichText styling around the token, explicitly adding to the text and newlines to the document structure, then deleting the token text.

This works great in my Notes 8.5.2 client so I've released this in the hope this is stable enough for general use, however it still regularly crashes when debugging, so your milage may vary.

If any issues occur using this function, then either modify your source worksheet to remove newlines, or modify the 'replaceTokenInBody' function code to remove the char(10) check (use the default 'findAndReplace' method.