Solved

Using VB6 to display the Category and Folder of an email in Outlook 2007

Posted on 2011-03-05

2 solutions

628 Views

Last Modified: 2012-05-11

We have a code that displays all the emails in Outlook 2007.

We want to also display the folder where its saved and also the category that is assign,

How can we incorporate this in our app?

(Included is part of the code, its in VB6)

Sub ProcessStore(olkFld As Object)
    Const olMailItem = 0
    Const olMail = 43
    Dim olkItm As Object, olkSub As Object, olkAtt As Object
    If olkFld.DefaultItemType = olMailItem Then
        For Each olkItm In olkFld.Items
            If olkItm.Class = olMail Then
                strBuffer = strBuffer & x & " - " & sp _
                          & olkItm.SentOn & sp & olkItm.ReceivedTime & sp & olkItm.SenderName & sp _
                          & olkItm.Subject & sp & olkItm.to & sp & olkItm.Body & vbCrLf
               'Display and export
                List.AddItem strBuffer
                Print #2, strBuffer
                strBuffer = ""
            End If
        Next
    End If
    
    For Each olkSub In olkFld.Folders
        ProcessStore olkSub
    Next
End Sub

Open in new window

Comment

Question by:rayluvs

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

7 Comments

LVL 2

Expert Comment

by:active_agent

ID: 350463932011-03-06

Just to confirm, you are looking to display the folder name and categories associated with the mail item.

- Folder Name : You are already passing the Folder object to ProcessStore, i believe there is Name property to that object.
- Category : Have you tried Categories property of mail item you were displaying.

Let me know how it goes.

Thanks

LVL 70

Expert Comment

by:Qlemo

ID: 350464202011-03-06

That is correct. If you want to display the complete path of the folder, you can use .FolderPath.
MailItem.Categories consists of a concatenated String of categories - so there can be more than one categorie in it.

Author Comment

by:rayluvs

ID: 350465622011-03-06

Yes , I am looking to display the folder name and categories associated with the mail item.

I tried ".FolderPath' and it gave me

Run-time error: '438'
Object doesn't support this property or method

How do I use MailItem.Categories to display the string or categories?

LVL 59

Accepted Solution

by:Chris Bottomley

Chris Bottomley earned 250 total points

ID: 350466322011-03-06

The parent is the folder therefore:
olkItm.parent.folderpath

and for the category string
olkitm.categories

Chris

LVL 70

Assisted Solution

by:Qlemo

Qlemo earned 250 total points

ID: 350466412011-03-06

I assume that is not your code? Because we thought you have some experience already, so we haven't been much detailled in our answers.

Chris is correct. You can access the folder path either by
olkItm.Parent.FolderPath
or, since we also have the folder itself ready,
olkFld.FolderPath

Author Comment

by:rayluvs

ID: 350467392011-03-06

Thanx, worked perfectly!

Author Closing Comment

by:rayluvs

ID: 350467442011-03-06

thanx

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

UTC Time in Outlook Appointments

Article by: Brenda

What does UTC stand for? “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation. What does th…

Outlook

How To Create A Meeting In Outlook 2007, 2010, 2013 & 2016?

Article by: Virat

In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.

How to access multiple mailboxes from one account in MS Exchange Server 2010 - video tutorial

Video by: Adam

There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…