Using a [Field] in an Email Body Text and maintain the line breaks

[BautistaC888]

Hello,

I need to use a field to use as a body for an email.
The mail body needs to conserve the line breaks from the body.

Thank you.

[PhilipMannering]

If the body is static you could just paste that into the Report Text Tool? As opposed it coming from a Text Input Tool...

[BautistaC888]

Hello,
Unfortunately, the body is dynamic. That is why i want to take it from a field. 

[PhilipMannering]

Can you share two different examples of the body?

[BautistaC888]

Ok, but it's not a fixed number of body.

[FreeRangeDingo]

I found this in the knowledge base -- https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Email-Tool-not-recognizing-newlines...

[PhilipMannering · Accepted solution]

Ah, so the whole body could change.

A couple of options worth trying,

1. Use the field directly in the Email Tool (i.e. without the Report Text Tool)

2. Replace new lines with <br/> in a Formula Tool and then use the field but treat as raw PCXML (example attached)

[FreeRangeDingo]

Then the Text column feeds into the Email tool as the body.  That works nicely.

[FreeRangeDingo]

Actually, you don't need the Report Text tool.  I liked this and was going to do a write up on it.  When I started building it out, I was able to get a good clean email without Report text and just using the expression.  Here are my inputs.

Here are the formulas.

And here is the email that comes out.