To get a non-default folder, you need to walk the folder hierarchy using the Folders collections or use a function that does that for you. For an example, see http://www.outlookcode.com/d/code/getfolder.htm.

Signature
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
> Hey all,
>
[quoted text clipped - 12 lines]
>
> Lance
Lance Hoffmeyer - 28 May 2008 16:29 GMT
Worked like a charm. Thanks.
Lance
Used
Set MyFolder = GetFolder("Public Folders\All
Public Folders\DDD\DDD Calendar").Items
Public Function GetFolder(strFolderPath As String)
As MAPIFolder
' strFolderPath needs to be something like
' "Public Folders\All Public
Folders\Company\Sales" or
' "Personal Folders\Inbox\My Folder"
Dim objApp As Outlook.Application
Dim objNS As Outlook.NameSpace
Dim colFolders As Outlook.Folders
Dim objFolder As Outlook.MAPIFolder
Dim arrFolders() As String
Dim I As Long
On Error Resume Next
strFolderPath = Replace(strFolderPath, "/", "\")
arrFolders() = Split(strFolderPath, "\")
Set objApp = Application
Set objNS = objApp.GetNamespace("MAPI")
Set objFolder = objNS.Folders.Item(arrFolders(0))
If Not objFolder Is Nothing Then
For I = 1 To UBound(arrFolders)
Set colFolders = objFolder.Folders
Set objFolder = Nothing
Set objFolder = colFolders.Item(arrFolders(I))
If objFolder Is Nothing Then
Exit For
End If
Next
End If
Set GetFolder = objFolder
Set colFolders = Nothing
Set objNS = Nothing
Set objApp = Nothing
End Function
> To get a non-default folder, you need to walk the folder hierarchy using the Folders collections or use a function that does that for you. For an example, see http://www.outlookcode.com/d/code/getfolder.htm.