I'm Lost! How can I pull data from emails?

[robertlevine]

I'm working in Access 97 (though I can use Access2000) and Outlook2000 and am trying to write a process that will go into a specified folder in a user's outlook and pull in the data from the emails there. The data will be in a standard csv format - but my biggest problem is trying to figure out how to systematically go into the folder, import the data from the email, and then move to the next email in the folder...

Any help would be much appreciated!

 

[The_Doc_Man]

First, this is an ActiveX / Automation / Application Object / Componet Object Model problem. (Bill Gates can't stay consistent in what he calls it.) You solve it by writing VBA code.

You need to get into OUTLOOK and examine its help files, including the help files for VBA within OUTLOOK (Tools>>Macro>>VBA).

Once you identify the objects defined for Outlook, you can get into those objects and examine them. The starting point, therefore, is to identify the things you can see. Identify the collection names and structure. Learn the properties you can tweak, examine, and flat-out clobber.

To do this from Access, you will, of course, have to know how to create application objects (such as an Outlook application object) so you can start enumerating the application's components to find what you want.

 

[richary]

I'm pretty sure there is some example code somewhere that will do what you want (the moving between emails bit). Try on the MS support site. I think it was intended to work pulling data from Outlook into Excel, but would be easily modified to work with Access.