Adding Outlook Object library for MAC Excel 2016.

Question

I have a Excel macro that works fine on Windows. However when i try to run that same macro in OSX, it gives me the error that "Missing: Microsoft Outlook xx Object Library". 

I have tried adding reference for this but cannot find the library listed in the system. 

Kindly suggest

Answer 1

I came across these lines somewhere and they work for me

        set myDate to current date

        set newAppointment to make new calendar event with properties {subject:theName, content:theContent, start time:myDate + 1 * hours, end time:myDate + (2 * hours)}

Answer 2

You will find this site informative:

Introduction to AppleScript Overview - developer.apple.com

In Finder, within the Applications folder, dragging the Outlook icon and dropping it onto the Script Editor icon will reveal the AppleScript dictionary, which is roughly the equivalent of using the Object Browser in VBA.

Answer 3

Hi Tapish

No, I never look for this, you must first see if this is possible with AppleScript and then you can make it work together with VBA. I can't promise that I have time soon to look at it.

Answer 4

Thanks for the suggestion Ron. BTW, do u have any examples for creating calendar appointments in a similar way, like taking rows from excel and adding then as appointments in outlook?

All the examples mentioned in the link shared are for sending emails.

Regards,

Tapish Agnihotri

Answer 5

There is no object model for Outlook for the Mac

I created some code that is maybe useful for you

http://www.rondebruin.nl/mac/macmail/macoutlook2016.htm