I am cheating a bit because I am not trying to solve a problem originating from Access. I am a retired teacher and many years ago wrote some VB code within Excel to automatically send emails from Outlook.
This was to automate the cover and invigilation problem that all schools face.
The school...