Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting Outlook mail into a DBF
Message
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:
01104112
Views:
9
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
Go raibh maith agat

~M
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform