开发者

Adding Outlook Object Library to Excel 2011 for Mac

开发者 https://www.devze.com 2023-04-10 05:24 出处：网络

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开发者_高级运维

相关专题：excel-2011 outlook outlook-addin

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.