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