I am trying to insert addresses into a template letter using the Replace function to replace some placeholder text.
I need to keep the address together using soft line breaks, so that it best fits the space allowed. The replacement text is provided by a database and is in plain text. I have no control over the final formatting of the document, I can only replace the placeholder texts.
One solution would be to force our users to have one placeholder per line of the address, but this may leave blank lines where an address field is not present, which is undesirable.
I have tried sending just a line feed (LF) character, just a carriage return (CR) character, and a combination CRLF but they all result in new paragraphs.
Can you give me any advice on how to achieve this.
Kind Regards
Darren