Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to add a new line for an email body?

Average_Badger
7 - Meteor

I need to add a line break/ new line after some statements in the body of an email.

I have in a formula tool: [filename] + ' ' + [creation_time] + ' ' + [record_count]

I need these to each be on new lines in the body of an email, and i cannot for the life of me figure out how to do this.  

 

9 REPLIES 9
patrick_digan
17 - Castor
17 - Castor

@Average_Badger Try just hitting enter on you keyboard in between the quotes, like:

 

[filename] + ' 
' + [creation_time] + ' 
' + [record_count]

I know it sounds silly, but I think should capture the new line.

 

 

Average_Badger
7 - Meteor

Ive tried that one, it does not seem to work

patrick_digan
17 - Castor
17 - Castor

@Average_Badger Ah I see :)

 

Have you tried the report text tool? I set one up like this:

Capture.PNG

You can click on the available fields dropdown to add your fields. Then it sent an email like this:

 

Capture.PNG

 

Let me know if that doesn't do it!

Average_Badger
7 - Meteor

AHA!  Yep that did it, thanks!

jkoh
5 - Atom

Thanks I was looking for this too!

Samuel_To
10 - Fireball

@patrick_digan 

 

Field 1
A
B
C
D

 

How about display muti records with newline ?

 

Email Body 

A

B

C

D

 

Best Regards,

Samuel

patrick_digan
17 - Castor
17 - Castor

@Samuel_To Use a summarize tool, concatenate the field and use the separator <br /> . That seemed to work on my end.

deepaprash
8 - Asteroid

Hello Patrick,

 

This is what I was looking for as well. However, I want to add a table in between the text. So the email would look like...

----------------------------------

Hello ABC,

 

We fsgvl klkdsfk klskflka.

 

TABLE

 

Continue with text..njahsdlkj. 

 

Thanks

GHJ

-----------------------------

 

If I insert the table in the Report Text tool, I get garbled results...

 

Is there a way around this?

 

Thanks!

Deepa

blacksoda
6 - Meteoroid

This was so helpful! Thanks a ton, Patrick! 

Labels