Using file to select email addresses after layout tool

[MattR79]

I have been asked to build a workflow to analyze data and then send out emails to 10+ separate distribution lists depending on whether that group has any issues that they need to look at.  Since the team composition changes rather frequently I have also been asked to use a separate file that the requesting team will maintain to dynamically select the email addresses based on a field in the distribution list file.  Easy enough when the output is going out as an Excel, however the team wants their emails formatted and set up in a way that requires use of several reporting tools.  Is there a way to tack on the email distribution after the final layout tool, or if not how should I format the layout tool in order to add the correct email distribution?  I will filter the email distribution lists prior to joining them to the final output so I'm just looking for how to add the email addresses in such a way that Alteryx can pick them up.  I have included an image of the output as an example of what is getting sent to the individual teams.

 

[apathetichell · Accepted solution]

you can use an append fields tool to append your reporting document to your email list.

[MattR79]

That worked perfectly!  Thank you.  Very simple solution to a problem that was confounding me for quite a while.