John W. Colby
jcolby at ColbyConsulting.com
Mon Mar 24 17:24:56 CST 2003
I wrote code for my users which looks for email (which had attachments we processed) in a specific folder. An outlook rule watched for the email and placed it into a subfolder. My Withevents class running in Access looked for email received events. Every email that came in caused the event to run, and my class then looked for email in the folder where this mail would be placed by the rule. If any email, open it, cycle through the attachments saving them to a backup directory, and also importing them into the database (two text files and an Excel file. 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 Drew Wutka Sent: Monday, March 24, 2003 6:11 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Drag and drop files and Emails on form for archive purpose. I completely agree that it is hard to guard against or program around dumb users. However, which is simpler? Asking a user to drag an email into an application (which would require that they have the application open, and also that they know how to drag from one window to another (a lot of times, they may have Outlook open maximized, which would prevent (on a single monitor machine) dragging an email anywhere.). Or telling them to just move 'specific' emails to a specific folder within their email? Drew -----Original Message----- From: Seth Galitzer [mailto:sgsax at ksu.edu] Sent: Monday, March 24, 2003 4:44 PM To: accessd Subject: RE: [AccessD] Drag and drop files and Emails on form for archive purpose. Drew, You don't know users very well. :) They don't want to have to think about it, they just want to do it. No matter how "dumbed down" you try to make the process, there will always be a dumber user. Saying, "copy the file to a folder," makes sense to you or me, but you can guarantee Joe User will give you a glazed look as soon as you try to explain why. Of course, Joe User may not understand "drag the file onto the application" either. Really, you can't win, but you can die trying. :) Seth On Mon, 2003-03-24 at 16:28, Drew Wutka wrote: > 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. > > ---- > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Seth Galitzer sgsax at ksu.edu Computing Specialist http://puma.agron.ksu.edu/~sgsax Dept. of Plant Pathology Kansas State University _______________________________________________ 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 ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 3916 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030324/c01f3f6f/attachment-0001.bin>