Drew Wutka
DWUTKA at marlow.com
Mon Mar 24 16:28:13 CST 2003
Just a thought. Why not have the users create a folder within their inbox. Have them drag emails they want 'recoreded' into that folder. Then create a service/routine that just runs through that folder, importing the data into access? Drew -----Original Message----- From: Erwin Craps [mailto:Erwin.Craps at ithelps.be] Sent: Saturday, March 22, 2003 4:10 AM To: 'accessd at databaseadvisors.com' Subject: [AccessD] Drag and drop files and Emails on form for archive purpose. Hi I already have a archive system for archiving outgooing emails and word doucments from an access database. But I need some archiving for Incoming correspondence to. I believe the only way to achief this is to have a sort of drag and drop function. The user should be able to drag a document from the explorer or from inside an email but also an e-mail itself to a form in access where a specific customer is already selected. This when dropping the object o this customer, access will save the object (file/email) in the same format (.DOC, .XLS, .MSG) and creating a customer related record with the filename into the archive table. What I'm basicly asking for is some easy or advanced code to see how the drag and drop works between Outlook/Explorer and Access and how I need to save the object to disk in its original format (.DOC, .MSG, .XLS, etc...). The document archiving system I already have, but I never used a drag and drop functionality... Thx Erwin. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030324/7b8b9b9b/attachment-0001.html>