This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When New lines (\n) are inserted into a concatenated field to separate the values, the email tool cannot read theses values. Here we have summarize tool which concatenates values into a single field and uses a newline (\n) separator. When this is parsed through the email tool, the body does not recognize the line break which means the email will display a single line or paragraph.
Thankfully there have been many community posts providing solutions on how to overcome this issue (see community posts at the end of this article). For the purposes of this example i will use the regex replace function along with Table reporting tool.
Step 1: Use a formula tool to replace \n with html break tags .
Step 2: Insert a Table tool from the Reporting palette Step 3. Attach the formula tool to the Table tool
Replace([Table],"<br />"," ")
Step 4: Finally attach the email tool which should produce the following results