Email tool to send attachment sending multiple emails

[cowannbell]

I have a workflow that outputs a excel file and I'm trying to use the email tool to send that attachment to an recipient.

I have a field in the file that has a formula for the attachment location.

I want to save the file to a share drive and then I want to email that file.

It keeps sending an email multiple times based on the numbers of rows in the file.

I have read prior discussions on this but can't seem to figure out the correct process.

Here is the last part of my workflow.  The email tool is configured to send the attachment based on the attachment field which is the formula for the location of the attachment.

Just trying to figure out how to get it to send only one email.

Thanks,

[atcodedog05]

Hi @cowannbell 

Please use a summarize tool groupby on location. This way it creates a single row and only one mail will be sent.

Workflow:

Hope this helps : )

[cowannbell]

I added the summarize tool and grouped on the file location field but it didn't send any email.

[atcodedog05]

Hi @cowannbell 

Can you share email tool config snapshot.

[cowannbell]

I changed some info for privacy reason but other than that, this is what it looks like.

[atcodedog05]

Hi @cowannbell 

Are you getting single row with filename from summarize tool to email tool.

Are you getting any error?

[cowannbell]

Yes, just the one row with just the filename field. No error.

[atcodedog05]

Hi @cowannbell 

Can you share the result messages log after workflow run.

[cowannbell]

It says it sent 1 email sent.  It finally came through.  Now one last question.  The file attachment does not have the name of the file it has another name like ATT18179.  How can I fix that?

[atcodedog05]

Hi @cowannbell 

You are passing required file path + file name as file location parameter to email tool right?

Are you getting a different name than passed?