Email notification when Excel sheet is saved

Hello,

I would like to know what would be the best macro code to get an email notification automatically after someone saved the specific excel file.

Thank you

.
Paste this macro into the ThisWorkbook module of the workbook :

Please Login or Register  to view this content.

The above assumes the end user has MS Outlook installed on their computer.

Thank you so much for your help.

Actually, I am looking for the code that will send an email notification automatically when the excel file is saved.

This code works perfectly but the email should be sent manually, and I am trying to avoid that. Would you be able to adjust it?

Thank you so much !

.
You are welcome.

Merry Christmas