Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting Outlook mail into a DBF
Message
From
14/03/2006 08:46:16
 
General information
Forum:
Visual FoxPro
Category:
CodeMine
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01104088
Message ID:
01104116
Views:
10
I think GetDefaultFolder(6) is the Inbox....


>something like below do? this looks for tasks but if you change the GetDefaultFolder(13) to GetDefaultFolder(4) i think it looks into email folder. some of the .subject items will be similar but you may want others
>
>loOutlook = createobject('outlook.application')
>loNamespace = loOutlook.GetNameSpace("mapi")
>loTaskbox = loNamespace.GetDefaultFolder(13)   && task folder
>loitems=lotaskbox.Items
>
>for v = 1 to loitems.count
>	loItem = loitems.item(v)
>	with loItem
>		? .Subject
>		**?.Duedate
>		**?.status
>		?.Body
>		**?.owner
>	endwith
>endfor
>
>Slán
>~M
>
>>I am looking for a simple way of connecting to a mailbox and extracting mail into a DBF. I have seen lots of options about this but I would like the snippets of code. Can anybody point me in the right direction please? Marcia has mentioned about Foxtalk November 2002 issue which takes you through this but I do not have a copy. Any help would be greatly appreciated.
>>
>>Many Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform