Macro to Send Copy of Excel file to personal email id.

hi,

I have a excel file, in which i maintain all my personal information. I update this excel as and when there is any new information. This file has some vital information which should not be lost at any point of time.
In order to maintain the file in multiple locations, i send the file manually to my personal email ids. In order to avoid sending the file manually, i am thinking of having macro in place which would take care of sending the copy of the file to personal email id ONCE AFTER I SAVE THE INFORMATION.

It would be great, if it pops up asking for email to send with Yes and No options. Upon Yes selection, the copy of the file would be sent and for NO, the action would be vice versa.

Please help, if anybody have any idea on this.

Thanks,
Vijay

Hi,

this link has everything you want and even some more :D. Check the example files, they are awesome.

http://www.rondebruin.nl/sendmail.htm