Need Help On designer desktop

[Sameer_Kanade8810]

Hi All, 
I have a data like below. For which i need to send email to example@gmail.com

This data will be my input file

Column A Column B  Column C
SAm          001             CALL

PRITI        002              TXT

Hazel         003             EMAIL

I need to derive the subject line based on Column C

And send 3 separate email email to example@gmail.com

The body should include the data 

EMail 1 Subject Call
Column A Column B  Column C
SAm          001             CALL

Email2 Subject txt

Column A Column B  Column C

PRITI        002              TXT

Email3 - Subject EMail

Column A Column B  Column C
Hazel         003             EMAIL

Can some please help.

[alexnajm]

From your data, you can use a Table tool to create your three tables by grouping on Column C. From there, you can use a Formula tool to create your dynamic Subject line!

This workflow should get you started, and you can take it from here. Please accept this response as a solution, and good luck!

[Hsandness]

Hi @Sameer_Kanade8810 ,

I would have three separate filters looking that filter on the values in column C. Then, use a formula tool to create the subject line. I wasn't sure what exactly you wanted for the email body but you can add your desired text and fields using the report text tool.

[Sameer_Kanade8810]

Hi @Hsandness 

What this works when i have a single user.

Lets say i have 

Columna A COlumn B COlumn C

Hazel        002             Call
Ronlad      002             Call

I need to send two separate email  

Email 1 Subject Call

Columna A COlumn B COlumn C
Hazel        002             Call


Email 2 Subject Call

Columna A COlumn B COlumn C
Ronlad      002             Call

Can this be done.

[binu_acs]

@Sameer_Kanade8810 @What @alexnajm suggested was the dynamic way of doing it, do you face any issues implementing that approach?

[Dhrish]

@Sameer_Kanade8810 For your requirement you can just modify @alexnajm workflow with adding a group by with Column A in the Table Tool.