Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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