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

Question

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

Answer 1

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.

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

Answer 2

Take a look at Ron de Bruin's site for much on emailing from Excel.

http://www.rondebruin.nl/win/section1.htm

Gord

Answer 3

Aloha Gord,

Thank you for you link. What a treasure trove of excel info. I'm still looking through the site but I have not yet found the answer I am looking for. 

Mahalo,

TheBMFIC

Answer 4

You say you want to send a worksheet as a message body.

I thought you meant you would copy/paste a range into the body as Ron shows here

http://www.rondebruin.nl/win/s1/outlook/bmail2.htm

I don't think there is a way of sending a worksheet in the body.

Gord

Answer 5

Aloha Gord & Vijay.

You guys Rock.  Vijay, It appears to work in the Terminal server and I will test the Windows 7 and Windows 8.1 workstations tomorrow.

Thank you very much.

Here are Excel 2016 screen shots

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.

You will see the mail icon above or below the ribbon.

Choose entire workbook or current sheet.

Add your recipient and click send.

I hope this helps.

The BMFIC.