You can usually do this by going to Start > “ Settings” > “ Apps” > “ Default Apps” and setting “ Email” to “ Outlook” or whatever email client you use. You might need to select a default email client in Windows. This brings up the VBA window: Go to Insert > Module Copy and Paste this into. Maybe you dont know or overlook the fact that theres a keystroke shortcut. Steps to Remove the Quick Access Toolbar Menu: Hit Alt + F11 on the keyboard. I performed these steps, but when I select the “Email” button, nothing happens. Maybe you havent even used Excel a whole lot, but youve recognized that heres an underline button, right here. Now the small “ EMail” icon will be available on the toolbar located at the upper-left corner of the window.Find “ Email” in the list of items on the left.Select “ Quick Access Toolbar” in the left pane.Right-click anywhere on the menu ribbon, then select “ Customize the ribbon…”.It contains commands that are used most often. If you want the envelope icon for even quicker access, follow these steps to enable the Mail envelope: The Quick Access Toolbar is located to the right of the Microsoft Office.

Now you should have an arrow you can click at the upper-left corner of the screen you can select, then quickly choose “ Email“.

If the Quick Access Toolbar isn’t visible, right-click anywhere on the menu ribbon, then select “ Show Quick Access Toolbar“.

Just to be clear, you can use the “ Share” button at the upper-right part of the screen to send your Excel file, but it takes 3 steps to email the file using this method.įollow these steps to add the quick Email option back to Excel or Word:

Excel 2016 quick access toolbar