<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Bericht</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=376052722-24032003><FONT face=Arial color=#0000ff size=2>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?</FONT></SPAN></DIV>
<DIV><SPAN class=376052722-24032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=376052722-24032003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Erwin Craps
[mailto:Erwin.Craps@ithelps.be]<BR><B>Sent:</B> Saturday, March 22, 2003 4:10
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD]
Drag and drop files and Emails on form for archive
purpose.<BR><BR></FONT></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial size=2>I already have a
archive system for archiving outgooing emails and word doucments from an
access database.</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial size=2>But I need some
archiving for Incoming correspondence to.</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial size=2>I believe the only
way to achief this is to have a sort of drag and drop
function.</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial size=2>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...).</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial size=2>The document
archiving system I already have, but I never used a drag and drop
functionality...</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2>Thx</FONT></SPAN></DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156460110-22032003><FONT face=Arial
size=2>Erwin.</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>