Send emails automatically even if attachments are open
- 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 All,
I have a workflow which sends email attachments to the users from Alteryx Gallery.
These attachments are available on shared drive and any 1 from my team can access these attachments.
Problem: When I am running this workflow it is getting failed because attachments are opened by someone. Is there a way where Alteryx should send emails even if the attachments are open by another user.
Thanks
- Labels:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kuntay
Unfortunately this is a challenge when working with Excel files. I believe what you'd need to do is make a copy of the excel file and then email the copy. Obviously any unsaved changes wouldn't be copied over, but I think this should work for you.
Here's a post that describes the general process you'd want to use:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx really insists on exclusive access to files it reads and writes.
Use the Before Run event to run a bat file that copies your file to another file that no one will open. Then have your workflow use the copy. DOS copy doesn't care if it is open or not. The /y option overwrites it if it is already there. If you want to keep the filename intact for attachment, copy to a different directory and keep the same filename.
