Multiple Emails sent when email tool too early in workflow

Hi,

Not sure why this behaviour happens but when I have the follow workflow:

Input Tool -> Select Tool -> Email Tool (with the output as the second branch), I see multiple emails for the same file.

But when I add another tool like Table (or anything else) and then put the email AFTER that tool, it sends the single email.

Is there a cleaner way to make this work? (the full workflow is more complicated and I don't want to have unnecessary tools on the workspace when I publish.

Mark

Output

Accepted answers

andre347

Alteryx will send out an e-mail for each record you're passing into the tool. You can use a summarize, or one of the reporting tools to bring this down to 1 row. I sometimes use a sample tool to just get the first row and pass that into the E-mail tool. This will mean it will only send out one e-mail when the workflow finishes running.

You can have the e-mail tool in your own Gallery, you can't use it in gallery.alteryx.com - this is prohibited but can you change that setting on your own server.

All comments

suli

The second one is the correct way... no unnecessary tools included there.

You are sending out multiple emails because in the section 'body' you are using a field.

1. You can also save a file with an output tool

AND

(2. Add 'block until done' before output, in the first output save file, in the second - send email with a file attachment

2. in workflow configuration-> events add an event (email) with the file you have just saved as an attachment.)

Btw. I think you cannot use email tool nor events in the gallery https://help.alteryx.com/10.0/PublishMessages.htm

Hope it helps!

andre347

You can have the e-mail tool in your own Gallery, you can't use it in gallery.alteryx.com - this is prohibited but can you change that setting on your own server.

ddiesel

@andre347... brilliant!

I was going crazy with the multiple emails and the sample tool did the trick! Thanks!

poojitha4

I have tried using the basic table tool->taking one row using the sample tool and send an email, but I get a blank email. If you could help, that will be helpful

WendyChen

Hi @andre347

When you mentioned you used summarize tool to make the email tool send out only one email. How did you configure your summarize tool?

Thanks!

Wendy

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335