E
Eric Chinn
I am converting an Access 2k SQL Project to a WinForms
C# .Net solution. The last technical hurdle in this
exercise is to replace the integration with Outlook 2000.
(Upgrading Outlook is not a solution!)
In the VBA system, a note facility exists which allows the
user to associate a note with (almost)any business entity
in the database. The note can be just text or it can be a
replication of an email generated in Outlook! In the case
of the later, the user selects an email address and an
entity descriptor subject from respective comboboxes and
clicks a button. The button click event instantiates
Outlook and displays a New Mail document with the selected
email address and entity descriptor Subject pre-set. (The
Subject has a prefix which is used to identify and
associate subsequent replies, as described below!) When
the user completes and sends the email, the body text is
captured via the "WithEvents" linkage and is added to the
database.
Additionally, whenever new mail is received by Outlook,
the WithEvents linkage intercepts the item and examines
the Subject looking for a note identifier(mentioned
above). If found, the essence of the email (sender, body,
date received) is saved and associated with the
originating note in the form of a conversation thread.
(This thread can be extended ad infinitum.)
Also, on Startup, the VBA system examines the user's
Outlook Inbox looking for any unprocessed reply messages
and integrates them into the database as above.
My challenge is to replicate this process in the C# .Net
solution!
C# .Net solution. The last technical hurdle in this
exercise is to replace the integration with Outlook 2000.
(Upgrading Outlook is not a solution!)
In the VBA system, a note facility exists which allows the
user to associate a note with (almost)any business entity
in the database. The note can be just text or it can be a
replication of an email generated in Outlook! In the case
of the later, the user selects an email address and an
entity descriptor subject from respective comboboxes and
clicks a button. The button click event instantiates
Outlook and displays a New Mail document with the selected
email address and entity descriptor Subject pre-set. (The
Subject has a prefix which is used to identify and
associate subsequent replies, as described below!) When
the user completes and sends the email, the body text is
captured via the "WithEvents" linkage and is added to the
database.
Additionally, whenever new mail is received by Outlook,
the WithEvents linkage intercepts the item and examines
the Subject looking for a note identifier(mentioned
above). If found, the essence of the email (sender, body,
date received) is saved and associated with the
originating note in the form of a conversation thread.
(This thread can be extended ad infinitum.)
Also, on Startup, the VBA system examines the user's
Outlook Inbox looking for any unprocessed reply messages
and integrates them into the database as above.
My challenge is to replicate this process in the C# .Net
solution!