Importing Outlook Data into Access

[ashleybyrdnc]

What I have done is create a custom form in outlook and I need to be able to get the data into Access. I really don't care where the marco resides in Access or in Outlook.

I have seen all the code for importing contacts but I am trying to pull data from emails/ then on top of that from custom fields. I would like for when my end user recieves the form filled out to be able to run a macro and append the data to access. But I don't mind having the end user save the email in a folder and then having the end user select the Folder from the macro. I have gotten parts of it to work but nothing together.

Does anyone have any sample code for this? Or can tell me where to look

 

[HiTechCoach]

I do know it is possible to write VBA code in office products that will write data into an Access database. I wrote code some VBA in Microsoft FrontPage that would store data about a web site in an Access databases.

While I have not actually tried to do it with Outlook, I do not see any reason why it is not possible. I say an example in Microsoft site a while back that used VBA code in Outlook to read an email, run a requested report in an Access database and send the results back.

My first thought would be to write VBA code in Outlook. You can find the Outlook Object Reference on Microsoft's site.