e-mail notification via Outlook

[Rob]

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.

 

[Bernie Deitrick]

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

 

[Ron de Bruin]

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

 

[Rob]

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