topic Re: Using a [Field] in an Email Body Text and maintain the line breaks in Alteryx Designer Desktop Discussions

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

BautistaC888 — Mon, 23 May 2022 20:58:20 GMT

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.

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

PhilipMannering — Mon, 23 May 2022 21:14:26 GMT

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

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

BautistaC888 — Mon, 23 May 2022 21:31:26 GMT

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

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

PhilipMannering — Mon, 23 May 2022 21:33:03 GMT

Can you share two different examples of the body?

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

BautistaC888 — Mon, 23 May 2022 21:39:00 GMT

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

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

FreeRangeDingo — Mon, 23 May 2022 21:53:35 GMT

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

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

PhilipMannering — Mon, 23 May 2022 21:54:25 GMT

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)

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

FreeRangeDingo — Mon, 23 May 2022 22:06:54 GMT

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

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

FreeRangeDingo — Mon, 23 May 2022 23:37:16 GMT

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.