FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Reading e-mails in Outlook
Posts: 1467
Joined: Mon Oct 10, 2005 11:26 AM
Reading e-mails in Outlook
Posted: Fri Dec 12, 2008 09:43 AM

Hello,

Can someone provide me with a working FWH-example how to read (unread) e-mails in Outlook with attachments ?

Thanks you very much in advance.

Regards,

Michel D.
Genk (Belgium)


_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

Posts: 1467
Joined: Mon Oct 10, 2005 11:26 AM
Reading e-mails in Outlook
Posted: Wed Dec 17, 2008 08:22 AM

Please ??????????????

Regards,

Michel D.
Genk (Belgium)


_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

Posts: 824
Joined: Thu Oct 13, 2005 07:39 AM
Reading e-mails in Outlook
Posted: Wed Dec 17, 2008 08:58 AM
Michel,

I found this sample in my archive, maybe it helps

#define olFolderInbox 6


FUNCTION MAIN()

    LOCAL oOutlook := CREATEOBJECT( "Outlook.Application" )
    LOCAL oNameSpace := oOutlook:GetNameSpace("MAPI")
    LOCAL oInbox := oNameSpace:GetDefaultFolder( olFolderInbox )

    LOCAL i

    FOR i = 1 TO oInbox:Items:Count
        ? oInbox:Items[ i ]:Body
        ?
    NEXT

    oOutlook:Quit()

    RETURN NIL
kind regards

Stefan
Posts: 1467
Joined: Mon Oct 10, 2005 11:26 AM
Reading e-mails in Outlook
Posted: Thu Dec 18, 2008 09:30 AM

Stefan,

Thanks a lot for your reaction.

But my problem is : how can I read the attachments ?

Thanks.

Regards,

Michel D.
Genk (Belgium)


_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

Posts: 824
Joined: Thu Oct 13, 2005 07:39 AM
Reading e-mails in Outlook
Posted: Fri Dec 19, 2008 08:46 AM

Michel,

I did´t find a sample reading attachments, sorry, maybe Enrico can help.

kind regards

Stefan
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Reading e-mails in Outlook
Posted: Fri Dec 19, 2008 09:51 AM
Michael,

you have to extend the code Stefan posted.

The lines are:
For Each anhang In myItem.Attachments
anhang.SaveAsFile myOrt & mail & "_" & anhang.FileName
'MsgBox (anhang.DisplayName)
Next
My code is VBA.

Please post back it it is working.

Regards,
Otto



Sub SaveEmail() 
Dim myItems, myItem As Object 
Dim myOrt As String 
Dim myOlApp As New Outlook.Application 
Dim myOlExp As Outlook.Explorer 
Dim myOlSel As Outlook.Selection 


Dim anhang As Outlook.Attachment 


myOrt = "c:\whoLIMP\" 
On Error Resume Next 
'work on selected items 
Set myOlExp = myOlApp.ActiveExplorer 
Set myOlSel = myOlExp.Selection 
'for all items do... 
For Each myItem In myOlSel 
myItem.SaveAs myOrt & "xxxx.txt", olTXT 

myItem.SaveAs myOrt & myItem.EntryID & ".txt", olTXT 
myItem.SaveAs myOrt & myItem.EntryID & ".msg", olMSG 


For Each anhang In myItem.Attachments 
anhang.SaveAsFile myOrt & mail & "_" & anhang.FileName 
'MsgBox (anhang.DisplayName) 
Next 



'myItem.Delete 
Next 
'free variables 
Set myItems = Nothing 
Set myItem = Nothing 
Set myOlApp = Nothing 
Set myOlExp = Nothing 
Set myOlSel = Nothing 
End Sub

Continue the discussion