I want(ed) to emulate all of the functionality that you get when you use the Outlook exoprt to DBF. This would be a single .dbf with a single .fpt, where there are columns for "subject" "fromname" etc and a memo column of "message" that actually has the mail.
>>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.
>
>I'm not sure what exactly do you want: to gather all children of oItem or to get only the concrete information.
>In first case you should use amember() function to retreive all properties of oItem and use the result to create a table. You can read more about outlook automation in "Automating Microsoft Outlook 97" chapter in MSDN. May be you want to save only recipients, subject, body and attachments information?