sending multiple dynamic emails from multiple rows

[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. 

[chukleswk]

You can first create the dynamic rows using the Formula Tool and then using the Report Text tool to create the body of the email as such: