Importing a Outlook Form into Access

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

Guest

Hi,

I've designed a Outlook form to capture consultant costs, details etc. I
would like to import the data into Access. However, when I try and import the
form through the Access wizard it locates the email but nothing more. I need
Access to be able to open the form and import the data contained within it.

I'll also post this message in the Access forum.

Cheers,

Phil
 
You will have to write your own code to do the import of the data or push it
to Access from Outlook.
 
Cheers Ken,

Any pointers where I might find some hints and tips of writing this code,
something to get me started.

Phil
 
When working with Outlook Forms, the user fields can be
accessed using the UserProperties object (which is a
member of the mail/appointment item in outlook.) If you
know the names of the fields you are accessing, you can
get the values out. Then, you could either directly
transfer these values to Access, or open up a ADO
connection to an Access database and put them in.
 
Back
Top