Step 3: Scroll down in the Reference Object library and select “Microsoft Outlook 16.0 Object Library” to make it available for Excel VBA.ĭepending on the Microsoft office, the Outlook version may be different. Step 2: Go to Tools and then select References as shown in the below screenshot. Step 1: In the Developer Tab click on Visual Basic to open the VB Editor.
