Email a Sheet from Excel online.

Question

We use Excel in our SharePoint so it's the online version of Excel. I want to create either a button or a text within a cell that would automatically when clicked or the text is entered would send that sheet to a predetermined email address.

Answer 1

Hello @Scott Wylie !

Welcome to Microsoft QnA!

I see youwant to Automate sending a Sheet to an Email address

A tool that is easy and already integrated into O365 in general is Power Automate

By using Power Automate, you can automate the process of sending Excel files from SharePoint to a predetermined email address. Although it doesn't involve adding a button directly within the Excel file,Power Automate allows you to achieve the desired functionality.

Here are some links with the Documentation

https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/excel

https://learn.microsoft.com/en-us/power-automate/triggers-introduction

A trigger would be the change into the file and an action would send the Email

Another way is to add the Hyperlink feature on Excel , but the Mail Client will open so the user must enter manually the recipient.

Of course Excel can support VBA Scripts but it is a rather old school solution and doe not offer the agility of Power Automate !

In case you need more details , kindly post your feedback and we can work on this.

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Answer 2

Lett me dig into you links and see if it gives me what I'm looking for.

Answer 3

It's a live Excel workbook within SharePoint. All I'm looking for is to be able to send a copy of the current sheet within the workbook to a predetermined email address. Similar to using Macros in the desktop version of Excel.

Answer 4

Basically yes.