Attach a dynamic named excel file in Email tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a workflow in which I have an excel file which is named according to the latest date and stored. I would like to attach this excel file as an attachment and send to recipients using the email tool.
A snapshot of the workflow
So, basis the date today the file will be named '2017_08_04.xlsx', and the name will change when I run the workflow tomorrow (2017_08_05.xlsx).
Is there a way by which I can send out the latest files everyday as attachments when the workflow is run?
Thanks,
Abhinaba
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@drahn may it be because you have specified the sheetname? When attaching a file you don't want to specify the sheetname you would want to send the entire file.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes - that was definitely it - so obvious! Thanks for pointing that out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I cannot for the life of me figure out how to get rid of the Filename column when sending this.
I can check the box in the output tool to make it not show up on that output, but then when it gets to the email part if Filename is not saved in the output, it has nothing to send.
i could figure this out without inserting today's date, but I need that in the file name.
Does anyone know how to do this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you using the Block Until Done tool like in the screen shot?
If you are, then you can un-check the "Keep Field in Output" box and the file-name field will still be present in the data stream that is feeding the email tool.
If you do it this way, the email tool does not know that you removed the file-name field from the output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How can such report be scheduled in Alteryx gallery so it can run at preset intervals? I am able to recreate the workflow to email a saved file and email that on a local machine but don't see a way to store and select the csv from alteryx gallery since the workflow need to be scheduled.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For Emails save your files you want to Attach in the Temporary Folder
The Temporary Directory is %Engine.TempFilePath% when used in a Tool’s Configuration for a File but when it’s in a Formula it’s [Egine.TempFilePath]
In the "Emai"l Tool, Click on Attachments, and then the “Add” button.
With the Formula Tool, create a filename with [Egine.TempFilePath] in front of it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am attempting to email an attachment and I am getting the email sent 80 times. How do I prevent the process from sending an email for each record in the attachment?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Add the "Sample" tool in front of the "Email" tool, as logically you need the connection but not all the rows.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That works thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Did you figure this out?
