Gustav Brock
Gustav at cactus.dk
Thu Sep 25 16:32:20 CDT 2008
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/>