Hi @bernardmwanza-0900 - no worries, office-scripts-excel-dev is the right tag :)

There isn't currently a way to send an email through Office Scripts but it absolutely is possible by integrating your script with Power Automate! See here for an example scenario involving emailing chart/table data generated by Office Scripts: https://docs.microsoft.com/en-us/office/dev/scripts/resources/samples/email-images-chart-table.

Nancy

Thanks for confirming! Office Scripts doesn't currently offer that functionality, but I'm curious if the Office Scripts + Power Automate integration might be useful here. Could you tell me a bit more about your scenario?

If you're interested, here's an example scenario that uses Office Scripts + Power Automate to cross-reference two different workbooks. You might be able to borrow concepts from here to build your automation: https://docs.microsoft.com/en-us/office/dev/scripts/resources/samples/excel-cross-reference

Nancy

Updating this thread with latest updates - we're currently releasing the ability to assign an Office Script to a workbook button. You can read more about this feature here: https://techcommunity.microsoft.com/t5/excel-blog/coming-soon-run-office-scripts-with-a-workbook-button/ba-p/2917021.

Thanks,
Nancy

Hi Angelo! Does this example scenario seem to fit what you're looking for? https://docs.microsoft.com/en-us/office/dev/scripts/resources/samples/email-images-chart-table

Nancy

Hi Angelo! Want to make sure I understand this correctly - when you press a button in your Excel workbook, you want to be able to add a new row to another Excel workbook. Is this right?

Thanks,
Nancy

Hey @MC2001-5695! Curious to learn more about this scenario - how do you schedule the script to run everyday? I'm wondering if you could use Power Automate to run the script, then add the resulting table to SharePoint with something like this: https://preview.flow.microsoft.com/en-us/galleries/public/templates/5b923a189f4448bd95d05def287f0d9d/create-an-item-in-sharepoint-for-a-selected-row/. Does this fit with what you're looking for?

Nancy

My apologies Prabhakaran! It seems like I copy/pasted the URL incorrectly - here's the right one: https://www.youtube.com/channel/UCPncyTU_HUNNcJS3Kol2n0w. I've updated my original answer to reflect this.