I have an overview sheet which takes conditions from other sheets to show when work is due. Is there a way i can set something up (a macro i presume?) to automatically send an email from myself to whoever it is that needs to complete a piece of work? (It will only ever be one of 3 people).

Thanks.