• GeniusConnect supports synchronization of the following Outlook / Exchange Folder types
  Microsoft® Outlook® 2002/2003/2007
  -Calendar
  -Contact
  -Mail
  -Task
  -Journal
  -Note
  Microsoft® Outlook® 2000
  -Contact 
• Link your own database schema
  Select your database table or view and link the columns to outlook fields. Define data conversion (int to char, date to char etc.) and SQL statements for generation of the primary key.
  
• Load 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.
  
• Store 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. 
  
• Load all items
  Load all database records in the outlook folder. If a 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 all items
  Store all outlook items from the outlook folder 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.
  
• Ignore private items
  Ignore all outlook items that are marked as private.
  
• Never update Outlook® items
  Never update outlook items that already exists in the contact folder.
• Never update database items
  Never update database data that already exists in the database.
  
• Delete Outlook® items when an item is removed from the database
  Delete Outlook® items that are deleted from the database. 
  
• Auto-synchronize
  Automatically load or store data based on schedulers.    
  
• Show progress
  Show progress dialog during loading or storing of data.   
  
• Link multiple folders
  Every outlook folder can be linked to a different table(and/or database).
  Example:
  Central database contains customer data in the customer table and supplier data in the supplier table.
  Link the contact folder “customers” to the customer table and the contact folder “suppliers” to the supplier table. 
  
• Import/ Export link setting
  Import or export information about link (mapping) between an Outlook® field and database table field from/to a file. 
  
• Customizable toolbar 
• Administrator password
  Configuration options can be protected by a password. 
  
• Filter Rows
  SQL where clause can be entered for every linked table.
  Specifies the condition for the rows returned by a query.
  It is possible to use dynamic parameters that will be replaced with system values during the synchronization.
• Status bar
  Synchronization process visible in Outlook® status bar if progress dialog not used.
  Process can be aborted by pressing a key. 
• Silent delete
  Outlook® items will be deleted without confirmation dialog. 
• Message class (form description)
  Outlook® field form description can be linked to a field. This is helpful for using custom forms. 
• ANSI quoted identifiers
  SQL statements are generated using ANSI quoted identifiers.
  Column/Table/View names with, for example, space characters or reserved keywords can be used.
  Use Checkbox on assign table dialog to set use of ANSI identifiers per folder. 
• User-defined fields
  Outlook User-defined fields can be linked to a table column.
  
  New Features third edition
• 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.
• Delete all Outlook Items before Load All
  All Outlook Item(s) will be deleted before Load All action. Use this option to empty the folder before loading all items. (Private Items will not be deleted if the "Only synchronize non-private items" options is used).
• Delete all Database Records before Store All
  All records will be deleted before Store All action. Use this option to empty the database table before storing all items. (If Filter is used: the where clause will be used for the delete action).
• Delete Database Record when Outlook Item deleted
  Database record will be deleted immediately after Outlook Item has been deleted. 
• Support for Calendar, Mail, Task, Journal, Note
  Not for Microsoft® Outlook® 2000
• Log info, warnings and errors to a file
• Html Body support
  It is now possible to link the HTML body text, it is still possible to use the plain text body.
• Deployment of folder links to different computers
• Extern Scheduler
  This option enables usage of external scheduler.
• Set sequence and direction for auto. synchronization per folder
• Block use of Outlook Status bar
• Block Error/Warning Message Box
• support for calendar Label column
• Basic support for Business Contact Manager Contacts
  (example .ini file included)
• Initial Sync
  associate Database records with Outlook items before first Load/Store
• Timestamp compare
  This option enables last modification time compare.Based on the timestamp, GeniusConnect can decide direction of the update. 
• Support for identity (autoincrement) primary keys
• New dynamic filter parameter {OUTLOOK_USER}
  (only Outlook 2003)
• Dynamic parameters availible also in SQL statements for primary/mandatory keys
• Customize Toolbar buttons behavior
• Support for Email MessageHeaders
  (property contains transport-specific message envelope information)
• Support for Contacts field in Appointments
• Automatic Folder Creation during Auto deployment
  (MultiUser only)
• Hide progress status details
• support for multiple MS Exchange user Mailboxes in Outlook
  this feature enables server based install of GeniusConnect. 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)
• Linked Contacts support for Journal and Contact folders
• Keywords Outlook data type conversion
  (from string array to a string value using a separator)
• Custom SQL commands
  (stored procedure, SQL Batch etc..) for Insert, Update and Delete
• Log errors and warnings to Windows event log
• New dynamic parameters
• Dynamic parameter inside custom SQL Commands
  Dynamic parameter can be used inside custom SQL Commands for Insert, Update and Delete
• Copy a folder configuration
  Copy a folder configuration to other folders of the same type
• New advanced option to set cache file
  (for slow networks/hosted exchange)
• Options to Ignore where filter during updates/deletes
• Prepare Load All optimized
• 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.
• Context menu on Database tab to manipulate folders and Export/Import settings
• GCScheduler options-auto start/end Outlook
• ODBC File DSN support
  File-based ODBC data sources can be shared among all users who have the same (network) drivers installed
• Delete Outlook Item in Initial Sync dialog (right click)
• Swiftpage Add-on
  support for email marketing campaigns directly from GeniusConnect. More info...
  
  New Features fourth edition
• Attachments support
  Outlook attachments can be mapped to a BLOB (binary large object) column 
• Contact pictures are also supported (as attachment)
• location Contact field
• New dynamic paramters for Exchange Mail box to identify Folder owner and Folder owner EntryID
• New configuration option "Only update and do not insert Database Items"
• Add Exchange Mailbox to GeniusConnect profile (Exchange and MultiUser license only)
• Convert UTC(Coordinated Universal Time) database values to local date-time
• Database change detection
  Use custom SQL commands/stored procedures to detect changes in table data
• Disable Toolbar buttons
  Disable toolbar Load/Store buttons per folder
   

Limitations:
Exceptions on recurring appointments and tasks are not supported.

Requirements
Microsoft® Outlook® 2000/XP/2003/2007