Intergrating with Email

[Don]

Hello, I have a Access 2003 front-end with a SQL Server 2005 backend. One CRM
part of the application tracks the activity with the customer in a traffic
log table. Sometimes the salesstaff has communication with their customer
using email instead. What do people do to synch this up with an application?
I was thinking about creating a form to enter the initial message, so I
could save it into a table and then have the system generate a email, of
course, this doesn't handle the email communication after the initial email.

Thanks

 

[Tom van Stiphout]

On Mon, 28 Sep 2009 19:44:01 -0700, Don

It would require advanced programming skills, but it is certainly
possible to monitor Outlook's events (using the WithEvents keyword)
and see if emails are related to records in the CRM database. We did
this in our company's CRM and now the user can for example create an
appointment in the CRM which creates same in Outlook, and then use
Outlook to move the appointment to another date, which then is
automatically adjusted in the CRM.

-Tom.
Microsoft Access MVP