e-mail notification via Outlook
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. |
e-mail notification via Outlook
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. |
e-mail notification via Outlook
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. |
e-mail notification via Outlook
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. |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com