Dear Friends,

I want to know how to send the current working excel file using Microsoft
Outlook or some other means as an attachment to my email id automatically
whenever the file is being Closed.

Kindly let me know how to achieve this using excel macros.

Thanks and Regards,
Sriram Subramaniyan

If you use MS Outlook you will ALWAYS get a Security Warning to prompt you
to click ALLOW before sending.

If you use Outlook Express you can Disable the Security Warning.

Set up a Button on your worksheet to save then email then Close or Exit
application.
http://www.vba-programmer.com/Snippe...o_Dialogs.html http://www.rondebruin.nl/mail/folder1/mail1.htmRegardsCorey"Sriram" wrote in ... Dear Friends, I want to know how to send the current working excel file using Microsoft Outlook or some other means as an attachment to my email id automatically whenever the file is being Closed. Kindly let me know how to achieve this using excel macros. Thanks and Regards, Sriram Subramaniyan

Hi Sriram

You can use CDO to avoid the warning
See
http://www.rondebruin.nl/mail/prevent.htm

You can use a event to run the macro
http://www.cpearson.com/excel/events.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sriram" wrote in message ...
Dear Friends,

I want to know how to send the current working excel file using Microsoft
Outlook or some other means as an attachment to my email id automatically
whenever the file is being Closed.

Kindly let me know how to achieve this using excel macros.

Thanks and Regards,
Sriram Subramaniyan