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

Question

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.NOClient NameOwners1Mr AOrange2Mr BBlue3Mr AOrange4Mr CGreen5Mr CBlueSo onand so onSo 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.NOClient NameOwners1Mr AOrange2Mr AOrange

Sl.NOClient NameOwners1Mr BBlue

Sl.NOClient NameOwners1Mr CGreen

Sl.NOClient NameOwners1Mr CBlue

Austin004lasrado · Answer

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

Austin004lasrado · Answer

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

FrederikE · Answer

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.