Jim Dettman
jimdettman at verizon.net
Mon Apr 9 19:27:24 CDT 2007
John, Sounds simple enough<g>. I know anti-virus packages do this all the time. Thankfully, I can standardize on Outlook as a client, so this shouldn't be a major hurdle. What's bouncing around in the back of my mind is working with the faxes as well. I haven't played around in the e-mail/fax area for a while now (used to use Winfax Pro<g>). I'm sure quite a bit has changed as has the products available. I also need to explore what Exchange has to offer for handling inbound faxes. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Monday, April 09, 2007 5:26 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Case management and external files I do the same. Outlook has a collection to hold messages. Each message has a collection to hold attachments. You can iterate these collections storing the objects as you wish. I "strip off" attachments all of the time simply by iterating the attachments collection and doing a save of the items. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Monday, April 09, 2007 5:07 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Case management and external files Regarding the attachments in emails: as has been pointed out, when you save such emails as .msg files the attachments are included. Regarding preventing the pesky users from damaging the stored files: I store the files somewhere on the network and the users get at the files via an Access app. When they select a file to examine the Access app *copies* the original to a predefined folder on the user's home drive, and then opens the copy for them to play with. When the Access application shuts down, any files found in the predefined folder are deleted. HTH Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Monday, April 09, 2007 3:55 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Case management and external files Greetings All, Question: anyone done work with case management and external files (i.e medical records, faxes, Word Docs, etc)? I know it's always best to leave them external, but beyond that: a. Any best practices you've found for linking them to a given case - i.e. do you tag them or place them in a per claim specific directory? b. How do you handle inbound faxes? Any recommendations on software? c. What about e-mails with attachments? Manual operation to cut/save the attachment or something more automatic? Any insights would be helpful. Thanks, Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com