Hi
I have a training matrix, where all staff are in column A , line manager is in column E. The training subject name is in column H,N,T,Z and so on witihn row 12. The due dates are witihin colums M,S,Y and so on. So i have been tasked with setting this up to spit out an automatic email to line managers when their particular members of staff have training due within the above days criteria. Can anyone please help with the method/application and code if VBA is to be used , which i think it will be. Also this needs to be dynamic so if we have leavers and new starters it is reflected in the emails sent so to speak.
I have a training matrix, where all staff are in column A , line manager is in column E. The training subject name is in column H,N,T,Z and so on witihn row 12. The due dates are witihin colums M,S,Y and so on. So i have been tasked with setting this up to spit out an automatic email to line managers when their particular members of staff have training due within the above days criteria. Can anyone please help with the method/application and code if VBA is to be used , which i think it will be. Also this needs to be dynamic so if we have leavers and new starters it is reflected in the emails sent so to speak.