What I need is for when a new locker is issued and the workers details are entered, a macro uses the workers email address to update them on their locker details. Only the info from the updated row should be sent to the email address in that row.

Microsoft Community

Microsoft Community