Send transaction data via email

My workflow does some normal row filtering to create a subset of the original file.  Then, I need to send out emails with transaction data from what remains in the data subset.

Basically, I need to include the header row combined with the rows that contain the Transaction Reference # for each individual email (each email should include the details for a unique Transaction Reference #).

I can't seem to connect the filtered data to the Send Emails node.  Does anyone have any ideas on how to accomplish this?


Hi Doug,

this workflow should give you an idea how it is done:


Basically, write the file in a temp file and use the flow variable in the send email node.

Cheers, Iris