Microsoft Outlook Object Library Missing

Question

Hi all,

I've searched this pretty thoroughly and cannot find an answer. I am trying to run a macro with VBA to pull emails from my inbox to excel. This code needs the outlook object library. However, when I go to Tools > References, Outlook Object Library is missing. I do not mean it says "Missing" in front of it like I have seen in some cases, I mean it simply is not there.

I am on a mac, running Big Sur 11.6. I have Office 365 downloaded.

Things I have tried:
Re-installing the entire microsoft suite
Browsing under "references" and following the file path listed on the other references (like Powerpoint Object Library) up to where outlook would be - however, this is grayed out and I cannot choose it
restarting pretty much everything

I saw that late binding might be an option but I am really new at this. My code is one I got from an online tutorial and while I have been trying to read enough to change my code I honestly have no idea what I'm doing. Ideally I could keep the code and find a way to enable the outlook object library. Everything online says as long as I have outlook installed I should have the library but it just doesn't exist.

Thanks for all your help

Answer 1

You may want to run an Office Repair from Control Panel > Programs and Features