Email tool

[subin1234]

Hi Guys,

Is there any way to attach the output of render tool to email. 

[BenMoss · Accepted solution]

@subin1234 the best option would be to not use the render tool at all and embed the table within the email.

Alternatively, you can write your file to a destination, then use the block until done tool and connect your email to this (ensuring the file is written before it is attached), and then using the 'Attach' option that exists within the email tool and point it at the location with which your render tool is writing too.

Ben

[subin1234]

Also how can we mail output from 2 render tool in a single mail. 

[BenMoss]

You can add your 2nd render tool to the 2nd stream and then you can add multiple attachments to the email.

When using the render tool I would consider choosing a very specific location with where to write the outputs, thus you know where the attachments will sit.

Ben

[DanC]

Hi @subin1234,

The Email tool is always the last tool to run in a workflow. Therefore, you can have multiple outputs created in a workflow and attached to a single Email tool without the need for a Block Until Done tool. Keep in mind that the files you plan to attach will have to have been created before you are able to configure the Email tool with the location and name of the attachments.

These articles may be of use to you as well:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Email/ta-p/32129

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Emailing-Different-Reports-to-Different-Reci...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Email-Tool-sending-endless-emails-How-to-sen...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Email-Tool-Order/ta-p/1233

Thank you!

[subin1234]

Hi

Please find the screenshot of my workflow

I have two render tool which will give me two excel files as output. I need to attach these two excel in one email tool. Also I need to add two tables in the body of the email. Is this can be done in any way. Please share sample workflow if possible.

[Lonny28]

---

@DanC wrote:

Hi @subin1234,

"The Email tool is always the last tool to run in a workflow."

---

Thank you so much for clarifying this - what if I don't want it to be last?  I have a workflow that builds a set of "Jobs" that a macro is about to run, and I want to be able to send a summary email ahead of time to let folks know that these jobs are about to run.

The Block Until Done tool obviously doesn't work here, because it goes onto the next step as soon as the last record passes through the first path.