Genius Connect 3.0.0.8

• Improved efficiency while working in Outlook through immediate access to current database information.
• Easy access to contact, calendar and customer information, stored in your database.
• Create Tasks in Outlook based on events in your database.
• Ability to quickly update and back-up information.
• Offers complete flexibility by allow connectivity to any standard SQL Database.

Microsoft Outlook 2002/2003
-Calendar
-Contact
-Mail
-Task
-Journal
-Note
Microsoft Outlook 2000
-Contact

• Link your own database schema - Select your database table and link the table 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 and store 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 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 on start or timer - Automatically load or store data based on timer.
• Import/ Export link setting - Import or export information about link (mapping) between an Outlook field and database table field from/to a file.
• 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.
• ANSI quoted identifiers - New checkbox on assign table dialog to set use of ANSI identifiers per folder.