Adding Outlook Email Tool In Excel 2010

Onetime 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 information technology with netmail. Stand out provides a tool around, which enables you to place information technology over with a single snap. This post illustrates how to make Email option apparent in Excel 2010, you bet to use it.

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

Set in motion Microsoft Excel2010, go to File computer menu, click Options, and in left pane click Customize Ribbon, in right pane select Altogether Commands from Choose commands throw-down options and look into for Email, Email as PDF Attachment, and Email as XPS Attachment commands. Now from left pane, hit Freshly Tab, change it's gens to Outlook, and then click New Chemical group to make mathematical group in the newly created check, pay it an appropriate make. Now click Add >> clitoris to add Email-related commands to newly created group. Click Okey to close Excel Options dialog.

Email insert 1

Now pilot to newly created Outlook tab key, 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 to datasheet A default Excel format (.xlsx), then clack Email along Expectation tab.

outlook 1

Mind-set mail window will open, you can see the attached Excel datasheet. At present you just need station it to the receiver.

outlook email

For sending datasheet arsenic PDF copy, click Netmail A PDF Attachment on Outlook tab. Mind-set mail window will open, showing PDF format atomic number 3 attached file.

pdf

Upon double-come home the attached file, you can open the datasheet in PDF format to verify the information positioning etc.

validate pdf

You can look into previously reviewed guides connected Excel 2010 Information Parallel bars & COUNTIF function in Excel 2010.