Making Dynamic Email

[ericren]

Hi everyone,

I need help constructing a dynamic email. Input file is below.

name	value	color	type
apples	23978293	blue	B

I would like to construct the email below. Everything bolded will be dynamic, referenced from the cells above. 

Text not in bold will be the template for this. 

Also, anyway to include bullets in alteryx email output?

Hello Team,

• The name is apples and it has a value of 23978293.
• It also is blue but it is type B. 

[Felipe_Ribeir0 · Accepted solution]

Hi @ericren 

You can use the text tool to do it, and then embed this text inside of the email body:

[martinding]

Hi @ericren ,

To add to Felipe's solution,

1) To have a dot point, you could just paste in a unicode dot character.

2) In the email tool, you choosen Body: Use Field --> Text

   

[ericren]

Hi,

What if I need multiple dynamic emails for multiple rows?

I want to send a dynamic email for each row that has data. Example below:

name	value	color	type
apples	23978293	blue	B
oranges	67345293	green	C
grapes	97545793	yellow	D

I would like to construct the email below. Everything bolded will be dynamic, referenced from the cells above. 

Text not in bold will be the template for this. 

Also, anyway to include bullets in alteryx email output?

Email 1:

Hello Team,

• The name is apples and it has a value of 23978293.
• It also is blue but it is type B. 

Email 2: 

Hello Team,

• The name is oranges and it has a value of 67345293.
• It also is green but it is type C. 

Email 3: 

Hello Team,

• The name is grapes and it has a value of 97545793.
• It also is yellow but it is type D.