e-mail notification via Outlook

  • Thread starter Thread starter Rob
  • Start date Start date
R

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.
 
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
 
Thank you both for your responses. I have used the SMTP for the mail.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unread e-mail count in Samsung Oreo update 3
E-mail Case 1
Sky e-mail via outlook 2
Sending e-mails from specific email address 2
Windows 10 operating system - using firefox browser - yahoo mail. 5
E-mail Notification Not Working 3
How do I send an e-mail in Outlook triggered by results in Excel? 1
E-mail notification not working 1

Back
Top