Question Microsoft Office 365 office365 Excel: setting up notification when an entry is made

Mar 12, 2019
4
0
10
0
Hi All
hoping someone can help and that this is the right place for my question, I am trying to setup a document via onedrive and sharing it with multiple people for multi user collaboration. The thing is i would like there to be some type of notification so when a user fills out the excel document an email is sent to selected users to let them know that the form has been filled out.
Is this possible, surely it is Microsoft after all.
 
You can set the documents into shared mode and it will track all the changes but nothings there to email you when changes happen. However you could write the VBA and use it in your document when you save it and it could email those people so I guess you could do it. You just need to learn visual basic for applications

VBA is fully supported in office apps
 

ASK THE COMMUNITY

TRENDING THREADS