Home | Products | Support | Subscriptions | About | Contact

Convert, Combine, Concatenate or Email any files or folder as PDF in a click from the comfort of your Windows Explorer with 'File to PDF for Windows'

Home Page | Download | How It Works | Videos

An add-in for Microsoft® Outlook® that makes it very easy and effortless to parse data from your mails, appointments, tasks or contacts and extract to a database, either manually or automatically - to archive, share or run reports on your Outlook data.
Database Exporter for Outlook enables you to export the contents of an Outlook folder to an external database. You can selectively specify which fields (built-in and user-defined fields) to include in the export, and the appropriate data type will be inherited in the database. Supports export of all different item types available in Outlook - mails, appointments, tasks, journals or contacts.

It can operate on any Outlook form, field types and support any Outlook folder, whether a private folder or an Exchange Public Folder. Optionally, export can also include Outlook subfolders.

Highlights: (Latest version: v5.1 released on 24th April 2018 - release note)


Seamless integration with Microsoft Outlook1


Export the contents of the Outlook folder to a relational database such as MS Access (MDB), Azure SQL, and all versions of SQL Server (including Express editions)


Support pre-defined Outlook fields as well as custom fields defined for that folder


Choose any customized form defined for that Outlook folder


Supports POP, IMAP, Exchange mailbox and Public folders


Export all kind of Outlook items – mails, posts, appointments, tasks, journals or contacts


Optionally include items from the subfolders in the export, either to a single table or to separate table for each subfolder


Supports export of notes (Plain Body or HTML Body of the Outlook item, including task, appointment and contact item).


Enumerated values for predefined Outlook fields are exported as readable values (e.g., Internal value for ‘Importance’ field of an Outlook item can be 0, 1 or 2. During export to a database, these values are translated to Normal, Low and High)


Real-time monitoring of incoming emails/new items of an Outlook folder, and automatically export the data to a database


Special MSI installer available for enterprise wide deployment (upon request)


Support for Office 2016 and 64 bit Versions


Support export to Microsoft Access and Microsoft SQL Server and cloud based Azure SQLNEW

1 Outlook Outlook 2007, Outlook 2010, Outlook 2013 and Outlook 2016 (both 32 bit and 64 bit)

Version: 5.1


Have any questions?
Email us: support@assistmyteam.net


Works with

30 days trial


Download brochure

New Page 1
Subscription License is valid for the subscribed term only. Technical assistance and upgrades are free for the subscribed term
Perpetual License is valid life-time. However, technical assistance and free upgrades are bound to the validity of the Support and Maintenance Contract

Free license for Academic Institutions (Schools, Colleges and Universities) - Learn More...
50% discount for non-profit, non-academic organizations (e.g., Charitable trusts, hospitals,). Learn More...

Purpose of this add-on

You have already customized an Outlook form with your own fields. At some point of time, you're going to want to put data into it or get that data out. But it might come as a big surprise that you cannot use Outlook's built-in Import and Export wizard to export data from custom forms. User-defined custom fields are absent on the data mapping grid in the export wizard. Even worse, you might not get any built-in Outlook fields data at all, if you try to export from items that were created with custom forms. So, you are forced to write codes to handle all import/export chores involving custom forms yourself. What worst is that, what you wrote works only for that particular Outlook form that you customized. What if you have many customized forms?

Database Exporter add-in for Microsoft Outlook is designed to overcome this limitation (i.e., the inability of the Outlook's built-in 'Import and Export Wizard' to handle data in custom forms), by allowing you to export any kind of data, including custom fields, to a database, in a simple click, or even better, on the fly with no intervention from the user.


How does it work?

With Database Exporter, there are 3 ways of exporting Outlook data to an external database, namely:

bullet Exporting items of an Outlook folder to a database
bullet Exporting Items including those in subfolders to a database
bullet Automatic live export of incoming emails or newly added appointments/tasks to a database


Exporting items of an Outlook folder to a database

To export the contents of an Outlook folder, click the ‘Export to DB’ button as shown below. You will be shown with the ‘Select Fields’ dialog, with which you can opt which form to be used for displaying the available fields.




By default, the first option ‘Retrieve from the first item’ is selected, and what it does is, to probe the first item of the folder and automatically seek out all the available fields, including any number of user defined custom fields. It is recommended that you stick with this option of displaying the fields, unless, you want to retrieve Outlook specific fields only (second option), or want to use a particular custom form out of many defined for that Outlook folder (third option).



Exporting items including those in subfolders

By default, when you export the contents of an Outlook folder using the ‘Export to DB’ button, only the items of the current folder is taken into account. Items inside the subfolders (if any) are excluded from the export. Below are a few export options available.


When exporting to database, include all items from subfolders - When you choose to export the contents of an Outlook folder, enable this option to include items in subfolders of any number of levels.

For example, below, the current folder is ‘My Company’. When exporting this to database, if you had checked this option, the contents of the subfolders such as ‘Bookings’, ‘Cases’, ‘Ongoing’, ‘Customers’ etc, will also be exported to the same database.

Export all data from all subfolders to a single table - Export all the items in the current folder, as well as those in subfolders in the same/single table, using this option. With this, the fields that you had chosen for the current folder will be applied to all the items in the subfolders as well.

Export data of each subfolder to separate table in same database - Another option is to export items in each of the subfolder to a separate table. This gives more flexibility in configuring the field options of the subfolders to be exported. For example, you can set the same chosen fields as that of the root folder, or use the default form for that subfolder, or even better, probe the first item of the subfolder to seek out the available fields. The latter option comes handy if you have user defined fields available on the folder or the item level.


Automation - Monitor an Outlook folder for live export to database

Database Exporter supports real-time monitoring of any number of Outlook folders (can be a public folder or shared mailbox folder too). This will automatically process incoming mails or newly added appointments, tasks or contact items and add the data for the chosen fields to the database, without any intervention from the user. This automation would be particular useful, if you want to maintain a parallel copy or backup of your current Outlook items.


Automatic export works by allowing Database Exporter to monitor selected Outlook folders (can be a shared or a public folder too), such that, when new emails are received or new appointments or tasks are added, Database Exporter automatically processes those items in real time and extract relevant data and add them to a pre-configured database. Each folder would have exactly one database each.

Automatically update DB record when Outlook item is updated/changed
– If you enable this option, whenever an existing Outlook item on a monitored folder is edited and saved, instantly the changes will also be reflected in the corresponding record in the database. This feature enables you to maintain synchronization between the Outlook items and the records in the database, on the fly, with no manual work.


Removing database record on item deletion from Outlook
If the Outlook folder is monitored for auto export, a delete button appears in the Database Exporter toolbar that enables you to delete the unnecessary Outlook items and at the same time, remove the corresponding database records automatically.


Automatic live export enables you to maintain a parallel copy of the Outlook data and keeps the database in synchronization with that particular Outlook folder. This spares you from having to do that laborious work of copying and pasting the data from Outlook to database manually.

Some useful external links related to this product:
bullet None
Copyright © 2019 AssistMyTeam. All rights reserved.


latest news from
OLAP & BI tool to analyze Microsoft SQL Server, Azure and Access database
Over the decade, businesses and organizations had accumulated a sea of data. However gaining insight from all this information has been challenging for most. Companies need to translate data into information to plan for future strategies... (22nd Mar'18)
Leverage Outlook for employee timesheet collection, payroll and billing
For many managers, the collection and processing of timesheets can be a slow and labor intensive work. And employees hate to fill out timesheets – a common universal fact which makes supervisors and managers constantly struggle to adopt an effective and accurate time tracking in the organization... (22nd Mar'18)
Turn Outlook into a Knowledge Base with Exchange Folders
Technology is driving and transforming business every day, but the ultimate goal is all about maximizing knowledge wealth and enhancing human intelligence. And for any organization, this acquired intelligence is the... (22nd Mar'18)

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.