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.

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.

Note that there is no security warning anymore if you run Office 2007

For more info see
http://www.rondebruin.nl/mail/prevent.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Bernie Deitrick" <deitbe @ consumer dot org wrote in message ...
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.

Thank you both for your responses. I have used the SMTP for the mail.

"Ron de Bruin" wrote:

Note that there is no security warning anymore if you run Office 2007

For more info see
http://www.rondebruin.nl/mail/prevent.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Bernie Deitrick" <deitbe @ consumer dot org wrote in message ...
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.