Outlook
A family of Microsoft email and calendar products.
3,719 questions
How to export a Web Excel sheet to Outlook using TypeScript?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 8%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Samantha Gomes
40
Reputation points
Hello,
I need help with the final step in the EoD report I have created. The EoD is written up in excel, its full of info on the amount of hours we worked on different builds, employee breakdowns, etc.
I have been trying to find a way to use TypeScript to export the sheet into an Outlook email. I know you can do that with desktop Excel and VBA, but I cant find details about how to do that with Web Excel and TypeScript.
Any help would be greatly appreciated!
{count} votes
-
Samantha Gomes 40 Reputation points
2023-09-14T12:16:01.3866667+00:00 Is this not possible in TypeScript?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sean Laberee 81 Reputation points Microsoft Employee2023-09-15T20:50:20.7166667+00:00 Hi Samantha,
You can accomplish the task you want using Office.JS inside of excel to get the cell contents and then using the Microsoft Graph to create and send an email.
https://learn.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-ranges-set-get-values
https://learn.microsoft.com/en-us/graph/api/user-sendmail?view=graph-rest-1.0&tabs=httpThat said, you may find it easier to accomplish the same task using PowerAutomate. You can create a flow that will read an excel spreadsheet, grab rows and then use a different task to compose and send the email.
I hope this helps!
-Sean
-
Samantha Gomes 40 Reputation points
2023-09-15T21:29:01.0633333+00:00 Hello Sean,
Thank you for the comment. I had first tried with PowerAutomate but it doesnt seem to do what I want.
PowerAutomate can yes extract data but its pretty limited in how it interacts with excel.
If I have PA pull all the data and plop it into the outlook commands, I would need to figure out the HTML scripts to actually format that.What I have been trying to figure out is how to put this into an email and look exactly the same. (I have made everything generic but this structure is accurate for my intention.)
How would I get this exact thing to appear in outlook?
Sign in to comment
Sign in to answer