Using vba to send attachments to Access 2007 database

  • Thread starter Thread starter Jack Jacobs
  • Start date Start date
J

Jack Jacobs

Hi all,

I would like to be able to send a (selection of) message als an
attachment to an attachment-field in an Access 2007 database.

So far no problem getting the connection to the database, either by
ADO or DAO. I can also manipulate data in the database. So what is my
problem?

The steps I'm taking are these:
-export selected message
-connect to database
- import message to attachment-field

The first two steps are qccomplished. Step three gives me the
headache.
Well, as far as I can see, you need a recordset2 (and field2) to
import files (using field2.LoadFromFile).

So my main question is: how can I use DAO.recordset2 and DAO.fields2
in Outlook vba? Am I missing something? I have references in my
project to Microsoft Acces 12,0 Object Library and Microsoft DAO 3.0
Object Library (among others).

Thanks in advance,

Jack
 
Back
Top