This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In this situation, I will write out an excel file to a temp location (using engine.tempfilepath in a formula tool to build the file path and name) then you can use this same tempfilepath to read the excel sheet back into the email tool as an attachment.
You may encounter read/write errors where the email tool tries to attach the file before it has finished being written to but a simple block until done can solve this.