question

KatelynMiller-4732 avatar image
0 Votes"
KatelynMiller-4732 asked TvanStiphout answered

Microsoft Outlook Object Library Missing

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.
133401-screen-shot-2021-09-19-at-42543-pm.png133337-screen-shot-2021-09-19-at-42625-pm.png

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

office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

TvanStiphout avatar image
0 Votes"
TvanStiphout answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.