VBA script reads outlook mailbox

months ago by Danny Riebeek
In one of our projects we needed to analyze email stored in outlook or office365 mailbox. We have written this utility in VBA that helped us do the job. [caption id="attachment_418" align="alignnone" width="406"]macro enabled workbook with vba script Excel sample[/caption] Download this macro enabled spreadsheet: InboxCalculatorV3

Purpose

VBA script reads outlook mailbox. Read outlook mail (you can specify which folder to process) into excel for further pivotting. [caption id="attachment_421" align="alignnone" width="1107"]Selecting outlook inbox folder Process of functionality[/caption]

Results

The results are written into Excel cells. You can adjust what is read and how it is written into Excel. [caption id="attachment_420" align="alignnone" width="1343"]excel output of vba script Results of VBA script[/caption]

VBA script reads outlook mailbox

Simple and generic sourcecode to connect to an outlook mailbox (local or office365) and read mail. [caption id="attachment_417" align="alignnone" width="858"]VBA script to read outlook VBA snippet[/caption] The sourcecode is free of use. Adjustments or improvements are always welcome. If you need support just leave a comment in this post.

LEAVE A REPLY