Sri NEED HELP - AUTO MAILING THE FILE WHILE CLOSING

[Sriram]

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

 

[Corey]

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/Snippets/Code_Excel/Saving_Workbook_no_Dialogs.html http://www.rondebruin.nl/mail/folder1/mail1.htmRegardsCorey"Sriram" <[email protected]> wrote in messageDear 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

 

[Ron de Bruin]

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