1. Home
  2. MS Office

Adding Outlook Email Tool In Excel 2010

Sometime it happens that you need to send Excel worksheets via email, but for that you don’t need to follow the orthodox way of sending datasheet by attaching it with email. Excel provides a tool, which enables you to send it over with a single click. This post illustrates how to make Email option apparent in Excel 2010, and how to use it.

Note: This procedure requires Outlook to be installed and configured on your computer

Launch Microsoft Excel2010, go to File menu, click Options, and in left pane click Customize Ribbon, in right pane select All Commands from Choose commands drop-down options and look for Email, Email as PDF Attachment, and Email as XPS Attachment commands. Now from left pane, hit New Tab, change it’s name to Outlook, and then click New Group to create group in the newly created tab, give it an appropriate name. Now click Add >> button to add Email-related commands to newly created group. Click OK to close Excel Options dialog.

Email insert 1

Now navigate to newly created Outlook tab, you will see commands added earlier.

outlook

Now open the datasheet which you want to attach with an email.

datasheet

If you want to attach datasheet as default Excel format (.xlsx), then click Email on Outlook tab.

outlook 1

Outlook mail window will open, you can see the attached Excel datasheet. Now you just need send it to the recipient.

outlook email

For sending datasheet as PDF copy, click Email as PDF Attachment on Outlook tab. Outlook mail window will open, showing PDF format as attached file.

pdf

Upon double-click the attached file, you can open the datasheet in PDF format to verify the data positioning etc.

validate pdf

You can check out previously reviewed guides on Excel 2010 Data Bars & COUNTIF function in Excel 2010.

9 Comments

  1. hello. what if i have a warning flag when some number is below 100, there is a way the “if” function could send an email if that happen?

  2. Hi,I Have MS outlook 2010.I want to paste the link of different emails in excel sheet.means when i click the link in excel it will open the required email.

  3. Like Shae I am trying to send just one sheet by email, not the whole workbook.  I’ve read the articles but it keeps sending the whole book.  Can just one sheet be sent??

  4. I setup the email tool as explained and it worked brillantly on my home computer but when i set it up on my work computer – it won’t let me just send one worksheet it keeps sending whole workbook please help

  5. This is a great tool but what if I want to make it really, really simple and have a button at the bottom of a form that when hit by the users of the form, will send the worksheet (form) to me in an Outlook e-mail? Everything I’ve seen on the web hasn’t worked. I have the button. I just need something to make it work.

    • @Duane – I’m also searching for a way to do this. I’ll let you know if I find anything close to that solution. I’m leaning towards VBA since everyone seems to be doing it that way. Let me know if you find another quick method.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.