Email all available excel files in single mail

[sparkle]

Hi Team, 

We have built workflow which creates multiple output files with different names. We need to send these multiple generated files in single email to specific recipient. 

So can someone help, how can we attach these multiple excel files in one email using email tool.

[jrlindem]

@sparkle this is definitely possible.  You'll need to start by having your files generated and using either Block-Unitl-Done or Control-Containers to ensure the files are fully written.  You'll also need to ensure that you capture (or specify) the exact drive (path) location the files are being written to along with their filename.  This is something you're going to use downstream in the Email tool.

Kind of like this:

Once you've got all that, you can call for an attachment in the Email tool using a field to reference the location:

You should be able to do this for one or many files.  Hope that gets you started in the right direction.  -Jay

[sparkle]

Hi @jrlindem ,
Yes i have used control containers.
i am facing issue with email tool. when i gave location path for files,  it is picking one file at a time and sending email. 

can you please share your workflow so i can configure it correctly at my side. 

[jrlindem]

@sparkle Let me mock up something that will support what i'm recommending.  I can't send the workflow that I screen-shot specifically.  If others jump in here and beat me to it, great!  But if not, i'll circle back today.

I know that what you might be facing is a list of files/paths and that's creating multiple rows going into the email tool, thus creating multiple emails right?  But if you crosstab the filepaths and then configure your email attachment to grab each of the filepath fields (which are all now separate instead of in a column list), you can achieve a single email with multiple attachments.

Try that in the meantime, and if I don't see a confirmation that his worked i'll get your an example.  -Jay

[jrlindem · Accepted solution]

@sparkle Okay, I've attached an example workflow.  It's also illustrated below.  Note that the email tool is going to show with configuration errors because I had to remove my company's SMTP.  You'll need to update that to reflect your info as well as the FROM and TO addresses.  I did test this successfully on my end so it should work fine for you once you resolve those bits of info.

You may also need to update the directory path or make sure your C-Drive has a folder called "Temp" in it for this test case to work.  Anyway, something like this (and attached):

Note the main part of this is the cross-tab tool feeding the email tool.  This makes sure you don't get multiple rows returning, that results in multiple emails (which you don't want).

I think this gets you there and you can adapt, in concept, from here.  Let me know how else I can help!

-Jay

[dreldrel]

You can attach your files in the Email tool

[sparkle]

HI @jrlindem ,

You are awesome, this solution worked for me just needed to tweak some pointers to update my workflow to get expected solution.