This process of setting the reference to “MICROSOFT OUTLOOK 16.0 OBJECT LIBRARY” is known as Early Binding. Now we can use the Microsoft Outlook object in Excel VBA. You can use “ Microsoft Outlook 14.0 Object Library ” if that is the version shown in your computer.Ĭheck the box of Microsoft Outlook as shown in the above screenshot. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |