A few words of thanks would be greatly appreciated.

Excel (VBA) - Open Outlook and send a file

Latest update on July 3, 2013 at 10:58 AM by jak58 .

Issue
Solution

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:

Excel vba open outlook
Open outlook from excel vba - Best answers
Vba open outlook - Best answers
Excel vba send outlook email with attachment - How-To - Excel
Excel vba create new sheet with name from cell - How-To - Excel
Excel vba copy data from one open workbook to another - How-To - Excel
Excel vba search - How-To - Excel
Excel vba add worksheet before first sheet - How-To - Excel

This document, titled « Excel (VBA) - Open Outlook and send a file », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

VBA - Create a series of buttons on a Excel worksheet

Excel - Add a custom background for your Comments