Page 1 of 1

How get message from dbx (Outlook Express)

Posted: Mon Apr 30, 2007 10:57 pm
by Romeo
Hi, i need to know all the folders and messages in the outlook express or microsoft outlook or more in general in the default mail of pc.

I found the following exampe for microsoft outlook and in tried to implement it.

****************************
oOL := TOleAuto():New( "Outlook.Application" )
lOutlookOK := .T.
IF ! lOutlookOK
RETURN ( 0 )
ENDIF

oNameSpace = oOL:Get( "GetNameSpace", "MAPI" )
oContacts = oNameSpace:Get( "GetDefaultFolder", "6" ) // 6 = Inbox-Folder

FOR nContador = 1 TO oContacts:ITEMS:Count()
oNewContact = oContacts:ITEMS( nContador )
cSenderName := oNewContact:get( "SenderName" )
cSubject := oNewContact:get( "Subject" )

cBody := oNewContact:get( "Body" )
NEXT nContador
RETURN NIL
********************

of course i dont know how to complete it.
I need for example to have all the folders of default mail (express/outlook/other) and the message and all the other information from an email/msg

Tks
Romeo

Posted: Mon Apr 30, 2007 11:46 pm
by James Bott
Romeo,

Outlook Express is not OLE capable.

James

Posted: Wed May 02, 2007 4:09 pm
by Romeo
Ok,
Could be possible to have a sample (for microsoft outlook) to get all the folders of mail and all the message.

I tried to have a look in the file VBAOUTL*.CHM, but i am not able to get the right informations.

tks

Posted: Thu May 03, 2007 3:54 pm
by WINHOTEL
This is a VBA Macro where I inserted some code to get all Emails from a folder.
Regards
Otto

Sub SaveEmail()
'Declaration
Dim itm As Outlook.MailItem

Set olItms = Application.ActiveExplorer.CurrentFolder.Items

On Error Resume Next
For Each itm In olItms
MsgBox (itm.SenderEmailAddress)
Next itm

End Sub

Posted: Thu May 03, 2007 4:01 pm
by Romeo
tks, in VBA it seems very simple.
But i use fwh, i tried
Romeo

Posted: Thu May 03, 2007 6:05 pm
by WINHOTEL
What for do you need this?
In my case I save the emails with a macro and than use a FW program with a timer which looks up the folder where the emails are saved.


Regards
Otto

Posted: Fri May 04, 2007 4:02 pm
by Romeo
It seems a god idea.
Of course i need VB...
Tks