Features and Requirements

All Features
  • Supported folder types
    Microsoft® Outlook® 2002 2003 2007 2010 2013 2016 2019 2021
    -Calendar
    -Contact
    -Mail
    -Task
    -Journal
    -Note
    Microsoft® Outlook® 2000
    -Contact
     
  • Link any database schema
    Select database table or view and link the columns to outlook fields. Define data conversions (int to char, date to char etc.).
  • Load / Import selected item(s)
    Load database data for selected outlook item(s) into the outlook folder and update the outlook item(s) data. The selected outlook item(s) will be updated only if a database record already exists.
  • Load / Import all items
    Load all database records in the outlook folder. If an outlook item already exists, the data will be updated. If the outlook item doesn’t exist, a new outlook item will be inserted into the outlook folder.
  • Store / Export selected item(s)
    Store selected outlook item(s) data in the database. If a database record already exists, the data will be updated. If a database record doesn’t exist, a new record will be inserted.
  • Store / Export all items
    Store all outlook folder items in the database. If a database record already exists, the data will be updated. If a database record doesn’t exist, a new record will be inserted.
  • Auto-synchronize
    Auto Synchronize on timers
    Set order and direction per Outlook folder, optionally auto start/stop Outlook 
    Auto Save on Outlook Item change
    Save Outlook Item(s) to database immediately after a change has been made. New Items will be automatically inserted.
    Database change detection
    Use custom SQL commands/stored procedures to detect changes in table data.
  • Timestamp compare
    This option enables last modification time compare. Based on the timestamp, GeniusConnect can decide direction of the update.
  • Filters
    Ignore private items
    Ignore all outlook items that are marked as private.
    SQL Filter
    SQL where clause can be entered for every linked table.
    Specifies the condition for the rows returned by a query.
  • User-defined fields
    Outlook User-defined fields can be linked to a table column.
  • Deleting
    Delete all Outlook Items before Load All
    Use this option to empty the folder before loading all items.
    Delete all Database Records before Store All
    Use this option to empty the table before storing all items.
    Delete Outlook items when an item is removed from the database
    Delete Outlook items that are deleted from the database.
    Delete Database Record when Outlook Item deleted
    Table record will be deleted immediately after Outlook Item has been deleted.
  • Link multiple folders
    Every outlook folder can be linked to a different table.
  • Import/ Export link setting
    Import or export foleder mapping configuration.
  • Administrator password
    Configuration options can be protected by a password.
  • Log info, warnings and errors to a file or event log
  • Html Body support
    Link the HTML body text to a table column, it is still possible to use the plain text body.
  • External Scheduler
    This option enables usage of external scheduler.
  • Basic support for Business Contact Manager Contacts
    (example .ini file included)
  • Initial Sync
    associate Database records with Outlook items before first Load/Store
  • Support for identity (auto-increment) primary keys
  • Automatic Folder Creation during Auto deployment
    (MultiUser only)
  • support for multiple Exchange user Mailboxes in Outlook
    It is possible to sync multiple MS Exchange user accounts from one Outlook installation. Changes made by the users from their PC's are automatically saved to the database (Auto Save option).MultiUser only.
  • Custom SQL commands
    overrule auto generated SQL commands for Insert, Update and Delete (custom stored procedures, SQL Batch etc..) . Custom SQL commands for Start-End sync...
  • Dynamic parameter
    Dynamic parameter(s) can be used in SQL filter or in custom SQL Commands for Insert, Update and Delete
  • Auto. Load selected item's
  • Follow Outlook offline mode
    The actions will be recorded and executed immediately after you switch back to online state. Scheduled synchronization and auto load are blocked in offline mode.
  • ODBC File DSN support
    File-based ODBC data sources can be shared among all users who have the same (network) drivers installed.
  • Support for mail date fields 
    Received date, SentOn date etc. in both directions-Export / Import
  • Attachments support
    Outlook attachments can be mapped to a BLOB (binary large object) column or extracted to a folder.
  • Contact pictures support (as attachment)
  • Convert UTC(Coordinated Universal Time) database values to local date-time

Limitations

Exceptions on recurring appointments and tasks are not supported.

Requirements

Microsoft® Outlook® 2000 2002 2003 2007 2010 2013 2016 2019 2021

License options...

Outlook versions Coexistence
Outlook 2016 or 2013 and an earlier version of Outlook... 
Outlook 2013-Coexistence with previous Outlook versions

  Outlook 2013-Coexistence (PDF)