Email update when Shared Spreadsheet is saved.

Question

I have shared Excel docs in Office 365 and I wanted to know is there a VB code to help me with this? I want to be able to get an email every time the shared document is saved. The documents are shared with 4 people and I would like to be able to know when someone has changed the document instead of opening it myself to see if there are changes. I do not need to know specifics I just need an email saying this document was saved.

Thanks.

Answer 1

Hi Jimmy,

There’s an easier way to get the email notification instead of doing this tasking through VB code, which may be more complex.

You can choose ‘Alert me’ option to get an email, whenever anything is changed in the document. You can create an alert for any document which is saved in your team site library or your personal document library.

To create an alert for a document shared from your team site library, please follow the steps below:

In classic library view

1. Login to Office 365>Admin> SharePoint
2. Navigate your SharePoint site>Document library, select the document.
3. On the ribbon, click ‘Files’ tab’>Alert me, as shown below

         

Once ‘New alert’ window is open, you can select from the options.

In modern library view, click on ellipses beside the document name >Alert me.

Please follow the steps below, to create an alert for a document shared from your personal document library i.e. OneDrive for Business.

1. Open OneDrive for Business, click on ‘Return to classic OneDrive’ on the bottom left corner.
2. Click on settings (gear icon on top right) > turn the Ribbon ‘On’
3. Select the document, on the ribbon, click ‘Files’ tab’>Alert me

Let me know if you need further help.

Thanks,

Neha

Answer 2

Thanks so much Neha that was just what I was looking for.

Answer 3

Hi Jimmy,

Have you tried setting an alert for a shared document? Do you need further help?

Thanks,

Neha

Answer 4

bump please