Ho to get notified by getting mail when any changes done in excel

  • Thread starter Thread starter Deep
  • Start date Start date
D

Deep

I would like to get informed by getting mails to ma, if any of the values of
the cells are changed
 
You can send an email by th following method you could put this as a
selection change but you would end up with a lot of emails.
If you want to trigger it when a specific cell or range are changed you
could compare each cell in the range on each selection change.
My preference would be to send email as a save event.
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = "Jimmy Page"
.Subject = "Changes to workbook"
.Body = "Changes have been made to workbook 1"
.Send
End With
On Error GoTo 0
Set OutMail = Nothing

Ron De Bruin has stacks of great stuff on email.
http://www.rondebruin.nl/mail/problems.htm
 

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

Back
Top