<div>
<div class="content wysiwyg-content">
I have a Microsoft Access 2013 application. &nbsp;I want to be able to dynamically access my Outlook email and search for keywords and return the results into a table that I can then format and report on. &nbsp;Is there a way to do this via an API from VBA? &nbsp;The scenario is that I get emails that are formatted a specific way with subject line content. &nbsp;I need to be able to mine this data.
</div>
</div>


I have a Microsoft Access 2013 application.  I want to be able to dynamically access my Outlook email and search for keywords and return the results into a table that I can then format and report on.  Is there a way to do this via an API from VBA?  The scenario is that I get emails that are formatted a specific way with subject line content.  I need to be able to mine this data.

Mine / Search Outlook messages from Access 2013

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.