Using vba to send attachments to Access 2007 database

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro: VBA code to move/forward email based on subjects and attachments 0
VBA Compile error when converting to Access 2007 4
Converting Access 2000 database to Access 2007 2
Importing access 2007 attachments into wss linked table 3
DAO references / Access 2007 2
No Attachment Warning - VBA Code HELP 1
Opening Outlook from Access 1
Recursively process message attachments 1

Top