When I save an excel sheet, I want Outlook to send an email to some intended recipients. Is that possible.



Situation:
There is a tracker which the team uses. I would like to put up a message box when the user save the sheet reading "Would you like to intimate the team about the change which happened in the tracker just now?". Is the user gives yes, Outlook should send an email subjecting which my content to intended recipients.

Thanks...

Hi,

Yes, the place to start when you want to send e-mails from Excel is Ron De Bruin's site:

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

Have a good read through the material (there's bound to be an example you can pretty much just copy to use) and feel free to post back if you have any follow up questions.

Hope that helps...