Dan Waters
dwaters at usinternet.com
Mon Apr 9 20:21:49 CDT 2007
Jim, The attachments are contained with the single file. Open an outlook email you've received that has an attachment. Save it as a separate file using .msg format. Now close Outlook. Now open that file, and you'll see the attachment with it! It's pretty nice! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Monday, April 09, 2007 7:27 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Case management and external files Dan, How do you view the attachments once they are in .msg format? I assume you'd need to go through Outlook, or do they show up as individual files? Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, April 09, 2007 4:55 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Case management and external files Hi Jim, I do this frequently. I copy the files that a user has selected and move the copies to a specific directory on the server where the db is stored. I also make the copies read-only so that when someone opens it (with a hyperlink path created at run-time in code), they can't store changes over the stored copy. I use File Systems Object for this. I guess an inbound fax would need to be scanned electronically to be stored as a file. Unless there is software that can be used to view a fax and save it as a separate file without printing it out. I have figured out how to pull emails from Outlook and save them as separate files in .msg format. I was surprised to find that when I did this, any attachments came right along with the email! I'll have to go through my code to find this, and I'll reply again tomorrow. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Monday, April 09, 2007 2: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