Adding Outlook Object Library to Excel 2011 for Mac

I am trying to move a VBA macro code from Excel 2003 to Excel 2011.

The macro requires sending an Email from Outlook. However, when I went to Tool > References to add the Outlook Object开发者_高级运维 Library, it does not show up in the List box.

How do I go about adding the reference in so i can access Outlook?

As of my knowledge Office Automation in the MAC world is somehow limited. Please see this discussion. Also this one in a Microsoft Forum..

You can add reference by using Browse option. You just need to add reference to the file "MSOUTL.OLB" In my system I have it in "C:\Program Files\Microsoft Office\Office12\MSOUTL.OLB" , In your system it could be in different folder.