home | products | services | support | knowledge base | free license | blog | about | contact


Product Overview
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.0 released on 3rd April 2017 - release note)
 

bullet

Seamless integration with Microsoft Outlook1

bullet

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)

bullet

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

bullet

Choose any customized form defined for that Outlook folder

bullet

Supports POP, IMAP, Exchange mailbox and Public folders

bullet

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

bullet

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

bullet

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

bullet

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)

bullet

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

bullet

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

bullet

Support for Office 2016 and 64 bit Versions

bullet

Support export to Microsoft Access and Microsoft SQL ServerNEW


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

Version: 5.0

 

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

 

 

Download brochure

30 days trial

Personal License (Single Seat)
75
USD

 

Country Enterprise License (Unlimited Seats)
6
00 USD

 
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 © 2017 AssistMyTeam. All rights reserved.
Press Releases | About
 
 

 

New! Take a video tour

Quickly learn how to use Database Exporter and export Outlook items to a database manually or on the fly

 

latest news from
bahrurBlog
Converting your emails and attachments to PDF without the fuss
Turning your emails and attachments into PDFs makes them portable, smaller, searchable and generally easier to view, print, store and share, independent of application software, hardware and operating systems.....(30th Jan'17)
 
Building solutions that work on both 32 bit and 64 bit native Office version
Today, 64 bit processors are found in most of our consumer and business systems. Because of its inherent capacity to support more virtual and physical memory than 32-bit ones..(18th Feb'13)
 

Seamless integration of SharePoint based Knowledge Base in Microsoft Outlook
It's simple! Computers are so much engraved in today's businesses, but in the end, the ultimate goal is all about maximizing knowledge wealth and enhancing human intelligence..(23rd Feb'12)

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