Jim Lawrence
accessd at shaw.ca
Sun Oct 5 14:34:11 CDT 2008
Excellent... that may be the answer to my problem as well. Thanks Gustav. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, September 25, 2008 2:32 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Integrating Email with Custom Client Database Hi Rocky One method could be to move all the e-mails to hMailServer: http://www.hmailserver.com and run this as either a mail store or an in-house mail server. All e-mails are stored as discrete files but all structured data are written as well to a database, MySQL or SQL Server. This you can access directly for fast searching. Also, hMS sports a COM interface and an API: http://www.hmailserver.com/documentation/?page=com_objects which allows you to control and access most events and methods of the server. And the price is right. /gustav >>> rockysmolin at bchacc.com 25-09-2008 18:22 >>> Dear List: A client with a law firm ahs a home-grown Access/SQL db for everything. They use Outlook but all emails are in one folder containing several tens of thousands of email. They have four thousand client. They have client contacts recorded but increasingly contacts are by email and so if they want to see a full history of interactions with a client they have to go to two places. Client would like some way to connect his client contacts with the emails. Has anyone had/solved this problem? MTIA, Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com