• Subject: Using vba to send attachments to Access 2007 database
  • Author: Jack Jacobs
  • Date: 21 Mar 2011
  • References:
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
21 Mar 2011Using vba to send attachments to Access 2007 database.Jack Jacobs
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)