Dynamically sending multiple emails based on a Group nd it can be N number of Groups

[Austin004lasrado]

Hello Al,

I need one help, where I have a Data, based on the Owners + Client (Multiple Owners + Multiple Clients) we need to create different attachment and it need to send different emails based as per the attachment generated by Alteryx, Email ID is same but Subject line needs to be defined based on Owner.

This is How the data will be

Sl.NO	Client Name	Owners
1	Mr A	Orange
2	Mr B	Blue
3	Mr A	Orange
4	Mr C	Green
5	Mr C	Blue
So on	and so on	So on

We need to Group the Client and Owners in one attachment and send email based on that group, since there can be N number of clients I am unable to use Filter tool option as it has to be pre-defined and we have multiple possibilities hence i need your help to do the same.

so please help me in splitting the  data like below and sending them in multiple emails.

What has to happen it. create a separate attachments like below and send different emails .

Sl.NO	Client Name	Owners
1	Mr A	Orange
2	Mr A	Orange

Sl.NO	Client Name	Owners
1	Mr B	Blue

Sl.NO	Client Name	Owners
1	Mr C	Green

Sl.NO	Client Name	Owners
1	Mr C	Blue

[FrederikE]

Hey @Austin004lasrado,

 

This WF should do. The "Owners" field is used here like it was an E-Mail Adress. 

[Austin004lasrado]

Thank you, i will try this and let you know 

[Austin004lasrado]

Hello @FrederikE , i am getting below error while i run this workflow, can you please help me with this error.

Error: Email (8): Record#1: Error Opening file: C:\Users\lasraus\Downloads\<div class="d52d89b0e524a492b956a12548be45a74" width="100%"><style>
.d52d89b0e524a492b956a12548be45a74 tbody .column0 { numeric:true; decimal-places:0; }
.d52d89b0e524a492b956a12548be45a74 thead .column0 { numeric:false; }
.d52d89b0e524a492b956a12548be45a74 .column0 { text-align:right; }
.d52d89b0e524a492b956a12548be45a74 thead .column1 { numeric:false; }
.d52d89b0e524a492b956a12548be45a74 .column1 { text-align:left; }
.d52d89b0e524a492b956a12548be45a74 thead .column2 { numeric:false; }
.d52d89b0e524a492b956a12548be45a74 .column2 { text-align:left; }
.d52d89b0e524a492b956a12548be45a74 tbody td { font-family: Arial; font-size:8; color:#000000; vertical-align:top; }
.d52d89b0e524a492b956a12548be45a74 tr.evenRow { background-color:#ffffff; }
.d52d89b0e524a492b956a12548be45a74 tr.oddRow { background-color:#f0f0f0; }
.d52d89b0e524a492b956a12548be45a74 thead tr { background-color:#dbdbdb; }
.d52d89b0e524a492b956a12548be45a74 thead td { vertical-align:top; font-family: Arial; font-size:10; color:#000000; }

<\style><datatable style="border: 1px solid #000000;" width="100%" cellspacing="0px" cellpadding="0px" rowGroupSize="1" rowsContained="3"><views><dataview><\dataview><\views><columns><col\><col\><col\><\columns><thead><tr class="headerRow"><td class="column0">SI.NO<\td><td class="column1">Client Name<\td><td class="column2">Owners<\td><\tr><\thead><dbody><dr><cell class=" column0 DefaultNumericText" style="" >1<\cell><cell class=" column1" style="" >Mr A<\cell><cell class=" column2" style="" >Orange<\cell><\dr><dr><cell class=" column0 DefaultNumericText" style="" >2<\cell><cell class=" column1" style="" >Mr A<\cell><cell class=" column2" style="" >Orange<\cell><\dr><\dbody><\datatable><\div>: The system cannot find the path specified. (3)

[FrederikE]

Hey @Austin004lasrado,

Looks like you selected "Attachments" and there the table. This option tries to locate a local file - which won't work here.

To use an In-Workflow table instead, select "Body" and there the Table field. 

 

[Austin004lasrado]

Thank you, is there a way we can do that as a attachment?, actually the tables are lengthy and do not want to update in an email body rather as a attachment 

[Austin004lasrado]

Hello @FrederikE  could you please help me in collating data in an attachment as the data in Email body becoming too lengthy and unreadable.