Ask a question »

Excel (VBA) - Open Outlook and send a file

July 2015


Excel (VBA) - Open Outlook and send a file




Issue


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?

Solution

  • 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:
Excel-vba-open-outlook-and-send-a-file.pdf

See also

In the same category

Published by jak58.
This document entitled « Excel (VBA) - Open Outlook and send a file » from CCM (ccm.net) 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.