I have a workflow which generates an xlsx file. The file opens without an issue locally.
I initially attempted to add a piece to the workflow where the file path for the attachment was passed along to the email tool, and the email sent out an email including this newly created file. All seemed to work until I tried to open the file and it was corrupt. I thought maybe it was a timing issue where it was trying to send the file while it was still being saved. I used CrewMacros Parallel Block Until Done tool so that stream one generated the file and stream two emailed the file. This did not work. I then added a 10 second wait after the file was created to begin the output of stream two which is the email. File still corrupted.
I then created a unique workflow and ran it after the other workflow was complete. Still an issue.
Any idea what could cause file corruption on an emailed xlsx file when locally the file is fine?
We use the Table reporting tool to manage the email body content, then select Table as the field for the email Body. That's really a better practice anyway, and it gives you dynamic value and HTML capabilities anyway.
@ntobon Do we have fix for this defect? I am unable to receive the excel file even with the workaround. Emailing a CSV does work with no issues however i cant go that route as my excel has multiple tabs. Thank you
Defect: "DE22485 - workflow runs and sends out the email message with the attachment, but the attachment is corrupted" is still open.
The workaround should work. Could you please provide a simplified version of your workflow so I can see how you are applying the workaround? Or provide a screen shot of the configuration on the Email tool.
Thank you Ntobon. I was able to do another workaround by using the Report Tool. It works perfectly fine. I was about to update the post and right time your response. Appreciate your help and fantastic community for all the help witout which i wuldnt have learnt a lot in this past 3 days.