Email a Sheet from Excel online.

Scott Wylie 20 Reputation points

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.

A family of Microsoft email and calendar products.
995 questions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
504 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,020 questions
0 comments No comments
{count} votes

Accepted answer
  1. Konstantinos Passadis 4,711 Reputation points

    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

    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!


    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Scott Wylie 20 Reputation points

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

  2. Scott Wylie 20 Reputation points

    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.

  3. Scott Wylie 20 Reputation points

    Basically yes.

    0 comments No comments