How to add outlook email tool in Excel 2010?

Many times a need arises where we need to send the Excel sheet contents as a mail and we follow the same old method of attaching the excel sheet as the attachment and then sending it through.

Here we are going to see a method where you can mail the excel sheet as a mail in just a single click. The follow steps will help you how to do that:

Step 1: Open Excel2010.

Step 2: Go to File menu and click on options.

Step 3: In the pane present in the left pane, click on the Customize Ribbon.

Step 4: Now in the Right pane, select “All Commands” in Choose commands from option.

Step 5: Click on the New Tab button.

Step 6: Change the name of the new tab to “Outlook”

Step 7: Click on the New Group button to create a new group in the newly created tab and give it a appropriate name.

Step 8: Select Email, Email as pdf attachment and Email as XPS Attachment one by one and click on Add button to wait for it to move to the right pane.

Step 9: Click on OK.

Step 10: Navigate to the outlook icon created now.

Step 10: Open the Excel sheet that you want to send as mail.

Step 11: Select the appropriate way of sending the mail i.e. as default format, as pdf attachment or as XPS attachment.

That’s all, now you can see outlook opening up itself with the excel sheet as the attachment in the desired format. All you need to do is to type in the sender’s mail id, Subject and the body and send.

Try this as it is very handy and will surely send a lot of time.