Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to get informed by getting mails to ma, if any of the values of
the cells are changed |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Deep" wrote: I would like to get informed by getting mails to ma, if any of the values of the cells are changed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I do an e-mail mail merge using an Excel spreadsheet? | Excel Worksheet Functions | |||
E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
Error: cannot load the mail service. Check your mail installation. | Excel Discussion (Misc queries) | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
How can I get notified whenever a certain excel file is updated (. | Excel Discussion (Misc queries) |