Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get a list of Outlook Message Subjects and Folder
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00486972
Message ID:
00487209
Views:
9
>Good Afternoon,
>
>I have been given a large PSt file from Outlook that contains Several levels of folders and a few thousand email messages distributed throughout the folders.
>
>Is there a way short of exporting each folder's contents to a table to get the subject, datesent, to, from and originating folder into a table. I haven't seen a way to export recursive folders information into a file.
>
>Is there a central database in Exchange 5 that I can access?
>
>Sincerely,
>
>Michael

You can certainly do this with Automation. Something along these lines:

oOutlook = CreateObject("Outlook.Application")
oNS = oOutlook.GetNameSpace("MAPI")

FOR EACH oFolder IN oNameSpace.Folders
This.BuildDBFFromFolder( oFolder)
ENDFOR

* Method BuildDBFFromFolder
LPARAMETERS oFolder

* First, use a loop to process all the items in the folder

* Then, go to subfolders
FOR EACH oSubFolder IN oFolder.Folders
This.BuildDBFFromFolder( oSubFolder)
ENDFOR

RETURN

This is totally untested code just to give you an idea where to go with this.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform