Recent content by GeorgeC47

I worked out how to format as code... If Range(teachercell) <> "" Then 'Create the outlook session. Set MyOlApp = CreateObject("Outlook.Application") 'Create appointment Set myitem = MyOlApp.CreateItem(olAppointmentItem) With myitem If...

Ooops, that of course should have been Office 2013. :o

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...