Hi everyone,
I'm trying to get the code to run as a macro to auto email a few people whenever any changes are made to a workbook that deals with peoples training.
So, each person in our team gets a copy of the training database. Whenever they make a change and update it, an email gets automatically sent out to about 6 people saying what changes were made. we can then make amendments to the MASTER copy of that workbook.
obviously, ideally we'd just have 1 workbook which peole could access on a shared drive and then an email notification gets sent out upon a change.
Hope you clever people can point me in the right direction.
Many thanks
Rob sutherland
I'm trying to get the code to run as a macro to auto email a few people whenever any changes are made to a workbook that deals with peoples training.
So, each person in our team gets a copy of the training database. Whenever they make a change and update it, an email gets automatically sent out to about 6 people saying what changes were made. we can then make amendments to the MASTER copy of that workbook.
obviously, ideally we'd just have 1 workbook which peole could access on a shared drive and then an email notification gets sent out upon a change.
Hope you clever people can point me in the right direction.
Many thanks
Rob sutherland
