Rob,

You can use the workbook's before save event to send mail. But - if you use Outlook, the user will
get a notification message saying "Somebody bad is trying to send an email".

So, you could try this workaround:

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

But your user would need to have outlook express or windows mail already available, or have an SMTP
server available.

HTH,
Bernie
MS Excel MVP


"Rob" wrote in message
...
I want to receive a e-mail when someone else saves a file. What coding can I
put in their file to automatically send me a e-mail when they save it, wether
changes have been made or not.