Import attachment from Outlook into Access

**Eric Legault [MVP - Outlook]** · March 27th 06, 08:58 PM posted to microsoft.public.outlook.program_vba

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.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

"Ocean" wrote:

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using VBA for Outlook and VBA for Access within Access	Sardonic	Outlook and VBA	1	March 17th 06 12:34 PM
Outlook not displaying attachment from Access via code	[email protected]	Outlook - General Queries	4	February 27th 06 11:30 PM
Can you import contacts from Outlook to Excel, Access, Word &how?	ericsayang	Outlook - General Queries	1	February 2nd 06 06:39 PM
How to import calendar appointments in outlook web access	ecunia	Outlook - Calandaring	1	January 30th 06 06:01 AM
Access to an attachment is blocked	tbahr	Outlook Express	4	January 13th 06 08:39 PM