How to Add Outlook 365 Object Library to Access 2010 VBA
Question details
The user needs to add the Outlook 365 Object Library to Microsoft Access 2010 VBA but faces issues getting the reference to stay selected when manually copying the .olb file.
- Product
- Microsoft Access 2010, Outlook 365
- Device & OS
- Windows 7
- Scenario
- Configuring VBA references in Access 2010 to automate or interface with Microsoft Outlook.
- Observed behavior
- Copying the msoutl.olb file to the computer and attempting to add it via Tools > References fails; the reference does not remain selected.
Verify that a compatible version of Microsoft Outlook is fully installed on your machine, as standalone .olb files cannot be referenced without the parent application.
Add Microsoft Outlook Object Library via VBA References
The standard method to add the Outlook Object Library when Microsoft Outlook is properly installed on the local machine.
To use early binding and access IntelliSense for Outlook objects, the full Outlook application must be installed. Simply copying the msoutl.olb file from another computer will not work because the library must be properly registered in the Windows Registry by the Office installer.
Open your Microsoft Access database and press Alt + F11 on your keyboard to launch the Visual Basic Editor.
Click on 'Tools' in the top menu bar and select 'References' from the dropdown menu.
Scroll through the 'Available References' list and check the box next to 'Microsoft Outlook 16.0 Object Library' (or the version corresponding to your Office 365 installation).
Click 'OK' to apply the reference. You can now declare and use Outlook objects in your VBA project.
Implement Late Binding to Bypass Reference Requirements
Use this solution if Outlook cannot be installed on the target machine or if you are deploying the Access database across environments with different Outlook versions.
Looking for a Lightweight, Hassle-Free Office Suite?
Dealing with complex VBA object library registrations and heavy MS Office standalone installations can be tedious. If you are looking for a reliable, lightweight alternative for your standard document, spreadsheet, and presentation tasks, WPS Office is an excellent choice.
Frequently Asked Questions
Why doesn't copying the msoutl.olb file fix my missing reference error?
Copying the .olb file alone is insufficient because VBA relies on the Windows Registry to locate and utilize COM objects. The full Microsoft Outlook installer properly registers the object library, which a simple file copy does not accomplish.
What is the difference between early binding and late binding in Access VBA?
Early binding requires checking a specific library in the Tools > References menu, which enables IntelliSense but restricts your database to that specific library version. Late binding declares objects generically at runtime using CreateObject, removing the need for strict library references and avoiding version compatibility errors.
Can I automate Outlook emails if I am using Access Runtime instead of the full Access version?
Yes, but you must ensure the target machine running the Runtime either has the matching version of Outlook installed locally, or you must use late binding in your VBA code to prevent the database from crashing due to a missing early-bound reference.
