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.
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)
If the body is static you could just paste that into the Report Text Tool? As opposed it coming from a Text Input Tool...
Hello,Unfortunately, the body is dynamic. That is why i want to take it from a field.
Can you share two different examples of the body?
Ok, but it's not a fixed number of body.
I found this in the knowledge base -- https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Email-Tool-not-recognizing-newlines-in-concatenated-field/ta-p/561690
Then the Text column feeds into the Email tool as the body. That works nicely.
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.
