Import attachment from Outlook into Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to import a text file attachment and paste the text into a memo field
in Access. Can anyone explain how I can achieve this?
Many thanks
 
The only real Outlook part of your question is with the Attachment object -
you can call the SaveAsFile method to save the .txt file to a location, then
use the TextStream object from the Microsoft Scripting Runtime Library to get
the actual text to write into a database record.

Another alternative is to use Redemption (http://www.dimastry.com), which
exposes an additional AsText property for a RDOAttachment object that the
Redemption library provides.
 
Back
Top