Tuesday, February 18, 2014

Sending an Excel workbook or worksheet attachment via Outlook 2010

In Excel 2002-2010 you have a option in the User Interface to mail a selection or worksheet in the body of the mail.
Excel 2002-2003 : You find this button next to the save icon in the Standard toolbar or use File>Send to>mail recipient.
Excel 2007-2010 : Microsoft hide it (It is not in the Office button>Send menu or in BackStage View)
But you can add this option to the QAT (Quick Access Toolbar)

  1. Office Button/File > Excel Options
  2. Customize (or Quick Access Toolbar in Excel 2010)
  3. Choose "Commands Not in the Ribbon" in the "Choose Commands from" list
  4. Select the command "Send to Mail Recipient"
  5. Add
  6. OK
Website where I found this info

http://www.asap-utilities.com/blog/index.php/2011/11/21/user-question-how-to-send-this-sheet-to-an-e-mail-in-excel-2010/

biz

0 Comments:

Post a Comment

<< Home