Does anyone have any quick-and-dirty code for programatically exporting Outlook mail items to a DBF? I have a 33mb .pst, and the export utility in Outlook XP (SP1 and all latest patches), crashes if I export to anything (dbf/mdb/txt/etc) other than another .pst.
Here's all I have so far. I need to create a DBF (but I don't know number/type/state of columns) and then step through each one to insert into the DBF. Help?
Local oOutlookObj as Outlook
oOutlookObj = CREATEOBJECT("Outlook.Application")
oNamespace = oOutlookObj.GetNamespace("MAPI")
oFolder = oNamespace.GetDefaultfolder(5)
For iCnt = 1 to (oFolder.Items.Count)
oItem = oFolder.Items(iCnt)
? iCnt
Next
I don't have my Hentzenwerke VFP-Office book handy, of course, so here I am.