Excel email notification when changed

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

automationnoob

Thread Starter
Joined
Feb 4, 2013
Messages
3

automationnoob

Thread Starter
Joined
Feb 4, 2013
Messages
3
Sorry, how do I attach a file? I have file ready to go but don't see any options to attach anything other than a link, if that is the case how do I work with the link? Really appreciate the help.
 

automationnoob

Thread Starter
Joined
Feb 4, 2013
Messages
3
I am using the 'before save' function because multiple users will be using this workbook (with no knowledge of advanced excel functions) so I don't want them to have to use a Hot Key. Thanks so much for the help. Got this working perfect now. The only other thing I would change (if you have any tips) is for the macro to only email if actual changes were made rather than just a 'save'.
 
Joined
Jun 29, 2012
Messages
518
This can be done most easily by using a Helper column. If you want emails to be sent, put a Yes in that column, and then when the emails are sent, the macro can remove the Yes. That is one way, there are many possibilities, another is, knowing the actual criteria to trigger the event like maybe Last Updated = today as an example. Esier still may be just a Command Button someone can click to purposely send the emails after they confirm they really want to send them.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top