Ask a question »

Excel (VBA) - Open Outlook and send a file

October 2015

Excel (VBA) - Open Outlook and send a file


I wonder if you can create a button (Type: OptionButton) which, when pressed automatically opens Outlook and automatically set the Excel file as mail attachment?


  • Office programs (Excel in particular) a feature exists to automate the sending of sheets by mail,.
    • (Send by mail the current file as an attachment)
  • On Excel 2007, simply click on :Menu/Send/Email

This function can be assigned to a button (using a macro).
Code used:
For unlimited offline reading, you can download this article for free in PDF format:

See also

In the same category

Published by jak58.
This document entitled « Excel (VBA) - Open Outlook and send a file » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.