locked
How to list Outlook emails into Excel using VBA on Mac Office 2011 RRS feed

  • Question

  • Hi there,

    I am new to VBA and office on Mac so I would really appreciate all kind of help. I am trying to write a Macro to list the emails (email sender, subject, etc) from Outlook in Excel in Mac 2011. However, there is no Microsoft Outlook 14.0 Object Library in my references and because I need to use the Outlook.Application in the macro , I cannot get it to work. 

    I was able to send an email through excel VBA with the help of the following link but how can I use this to read emails from Outlook ?

    https://msdn.microsoft.com/en-us/library/office/Hh859489(v=Office.14).aspx

    Thanks


    Wednesday, September 2, 2015 6:06 AM

Answers

  • Hi zeynep ert,

    This forum is for developers discussing developing issues on Windows platform. Since the issue is more relative to on Mac, I suggest that you reopen a new thread in form below:
    http://answers.microsoft.com/en-us/mac/forum/macoutlook?tab=Threads

    >> However, there is no Microsoft Outlook 14.0 Object Library in my references and because I need to use the Outlook.Application in the macro , I cannot get it to work. <<

    Based on my understanding, the Outlook 14.0 Object Library is the reference for Outlook 2010 on Windows platform.

    Hope it is helpful.

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Just Karl Wednesday, September 2, 2015 2:24 PM
    • Marked as answer by Just Karl Friday, September 11, 2015 7:57 PM
    Wednesday, September 2, 2015 8:57 AM