Importing a Outlook Form into Access

[PW11111]

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

 

[Ken Slovak - [MVP - Outlook]]

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

 

[PW11111]

Cheers Ken,

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

Phil

 

[Guest]

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.

 

[Ken Slovak - [MVP - Outlook]]

There's a lot of information and samples at
http://www.outlookcode.com/d/database.htm that should get you started.