How to extract Employee data from Outlook to Excel for Analysis

Photo by Sebastian Herrmann on Unsplash

In this post, I am going to show how to use Outlook VBA code to extract employee Info for Analysis. The MSDN docs to work with Outlook VBA model and EXCEL VBA model are available online in the Microsoft website, The link to the websites are given below,

Outlook Visual Basic for Applications (VBA) reference

Excel Visual Basic for Applications (VBA) reference

Using the VBA reference , you can develop applications specific to Outlook for various programming tasks .

To enable visual basic editor, go to outlook options and enable the developer tab.

Enable Developer TAB

Now click on the visual basic editor,

Create a new Module