Share via

How to add 'Send Mail to a Recipient' in Excel 2016 spreadsheet (not mail as an attachment)

Anonymous
2015-11-12T23:18:55+00:00

Aloha ALCON,

I would like our Excel 2016 to have the option to 'Send Mail to a Recipient'. How may I do that with Excel 2016?

We want to send a worksheet as message body of an email. We are using using Office 2016 and Outlook 2016 as our mail client. There is an in house 2016 Exhcange server

We will be using VLK licensing on workstations running Windows 7pro  Windows 8.1pro and a 2012 terminal server.  

Mahalo,

TheBMFIC

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2015-11-13T06:52:18+00:00

    Do following. The screenshots are from Excel 2013 and should be applicable to Excel 2016 as well.

    1. File > Options > Quick Access Toolbar > Choose "All Commands" in Choose Commands From: box > Select "Send to Mail Recipient" and Add to right side. Now, this icon will be added to QAT.

    1. Now, press this icon in QAT and you will get the option to send either Worksheet or Workbook to mail.

    10 people found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-11-13T15:36:03+00:00

    I learned something new.

    Funny how that just keeps occurring<>

    Gord

    0 comments
  2. Anonymous
    2017-10-06T13:19:34+00:00

    Save and Send is under SHARE and then EMAIL.  The icons are there.  For some reason Microsoft programmers LOVE LOVE LOVE to bury things so that you are constantly asking where is this... where is that.

    0 comments