Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   List of Folders (http://www.outlookbanter.com/outlook-vba/45405-list-folders.html)

Daniel April 6th 07 07:34 PM

List of Folders
 
Hello,

I am try, through Access, to retrieve a complete listing of all the contact
folder for an outllok profile. Could someone give me a good nudge in the
right direction. I am new at programming with Outlook so please give as much
detail as possible.

Thank you for the help,

Daniel P

Michael Bauer [MVP - Outlook] April 9th 07 07:34 AM

List of Folders
 

Here's a sample for how to loop through all of the folders:

Public Sub LoopFolders(oFolders As Outlook.Folders, _
ByVal bRecursive As Boolean _
)
Dim oFld As Outlook.MapiFolder

For Each oFld In oFolders
If oFld.DefaultItemType = olContactItem Then
' Contact folder
End If

If bRecursive Then
If oFld.Folders.Count Then
LoopFolders oFld.Folders, bRecursive
End If
End If
Next
End Sub

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Fri, 6 Apr 2007 11:34:03 -0700 schrieb Daniel:

Hello,

I am try, through Access, to retrieve a complete listing of all the

contact
folder for an outllok profile. Could someone give me a good nudge in the
right direction. I am new at programming with Outlook so please give as

much
detail as possible.

Thank you for the help,

Daniel P


greggmendel October 2nd 07 12:02 AM

List of Folders
 
Nooby question he I get a 424 (Object Required) message at execute time on
the "For Each oFld In oFolders" line. What might I be doing wrong?

"Michael Bauer [MVP - Outlook]" wrote:


Here's a sample for how to loop through all of the folders:

Public Sub LoopFolders(oFolders As Outlook.Folders, _
ByVal bRecursive As Boolean _
)
Dim oFld As Outlook.MapiFolder

For Each oFld In oFolders
If oFld.DefaultItemType = olContactItem Then
' Contact folder
End If

If bRecursive Then
If oFld.Folders.Count Then
LoopFolders oFld.Folders, bRecursive
End If
End If
Next
End Sub

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Fri, 6 Apr 2007 11:34:03 -0700 schrieb Daniel:

Hello,

I am try, through Access, to retrieve a complete listing of all the

contact
folder for an outllok profile. Could someone give me a good nudge in the
right direction. I am new at programming with Outlook so please give as

much
detail as possible.

Thank you for the help,

Daniel P




All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com