2 emails tool

[serclau0623]

Hello, 

I have a workflow with 2 emails tool that once they are running independently works fine and I receive 2 emails however once I run them together for some reason only receive one of them, any advise please?

Thank you

[WesCannon]

Hi @serclau0623 

I have a few suggestions you can leverage to get this working:

1. My first suggestion would be to re-configure the workflow so the 'Block Until Done Tool' & 'Email Tool' can be used as shown below. I was able to successfully send both emails using this approach. 

2. Troubleshoot your current 'Block Until Done' Tools as outlined below and in more detail here 

Troubleshoot Data Stream Sequence

When 2 or more Block Until Done tools are on the canvas, Designer must evaluate which related data stream to run.

• Designer 1st determines the order in which each tool was added to the workflow using the tool's Tool ID.
• Designer then runs the data stream that contains the tool that was added 1st (lowest Tool ID.)

If data streams don't run in the expected order, check the Tool ID of the tools upstream from the Block Until Done tools. To check tool ID...

1. Select the tool.
2. In the Configuration window, access the Annotation tab.
3. Use ID to see what number is assigned to the tool. This number indicates the order in which the tool was added to the workflow.

3. Use one 'Email Tool' and union all records together before emailing. Then utilize the 'Use Fields' function.

I hope this helps!

Thanks,

Wes

[serclau0623]

Thank you so much! 

I eliminated 1 of the block until done and 1 of the email tool, that way generate only 1 email (Debits & Credits) and it is working fine but unfortunately I got this new filename  error message

[Felipe_Ribeir0]

Hi @serclau0623 

When you provide .xlsx filepaths to the email tool, they must go just until .xlsx. You are providing .xlsx|||Sheet1. Remove the |||Sheet1 from it to feed the email tool and it should work.

[WesCannon]

Hi @serclau0623 ,

Please remove the sheet names as Felipe mentioned. Here is another discussion on the topic for further details.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-not-get-the-E-mail-tool-to-recongn...

Thanks,

Wes

[serclau0623]

Thank you both, I removed the Sheet name and got the same error message.

[WesCannon]

Hi @serclau0623,

Are you attempting to write the file via the 'Output Tool' prior to sending the email? Using a 'Block Until Done Tool' could be useful here to first write the file then send the email.