Next up is how can I get vba to open Entourage and send an email with an attached worksheet?
I used to do it to send an absence list from my register to the correct Head of Year within the school. Sadly I have lost all the code I used as it was on a Windows version of Excel and worked with Outlook.
Anyone know how to do it?