I'm missing something in my code... It is not looping further into subfolders (as the msgbox states).
Can you please advise what's missing? Thanks!
Private Sub cmdEmailFolders2_Click()
'12/1/07 outlook folders button
Dim y As Integer
Dim outApp As New outlook.Application
Dim nsp As outlook.NameSpace
Dim mpf As outlook.MAPIFolder
Dim mpfSubFolder As outlook.MAPIFolder
Dim flds As outlook.Folders
Dim flds2 As outlook.Folders
Dim idx As Integer
Dim myItem As outlook.MailItem
Set nsp = outApp.GetNamespace("MAPI"
)
Set mpf = nsp.GetDefaultFolder(olFol
derInbox)
Set flds = mpf.Folders
Set mpfSubFolder = flds.GetFirst
Dim myNewFolder As outlook.MAPIFolder
Do While Not mpfSubFolder Is Nothing 'client name
Debug.Print mpfSubFolder.Name
Set myNewFolder = mpfSubFolder
For i = 1 To myNewFolder.Folders.count 'debt
Debug.Print myNewFolder.Folders.Item(i
) '.Items(1)
If myNewFolder.Folders.Item(i
).Folders.
count = 0 Then
Else
For A = 1 To myNewFolder.Folders.Item(i
).Folders.
count 'client
' Debug.Print myNewFolder.Folders.Item(i
) 'debt
Set myFolder = myNewFolder.Folders.Item(i
).Folders.
Item(A) 'open trades
Debug.Print myNewFolder.Folders.Item(i
).Folders.
Item(A)
Debug.Print myNewFolder.Folders.Item(i
).Folders.
Item(A).It
ems.count
For x = 1 To myNewFolder.Folders.Item(i
).Folders.
Item(A).It
ems.count
Debug.Print myNewFolder.Folders.Item(i
).Folders.
Item(A).It
ems(x)
Set myItem = myNewFolder.Folders.Item(i
).Folders.
Item(A).It
ems(x)
'>>>>>>>>never getting in here
MsgBox "never getting to this point even when there are subfolders"
Next x
Next A
End If 'SUBFOLDER COUNT =0
Next i
Set mpfSubFolder = flds.GetNext
Loop
Exit Sub
End Sub
Start Free Trial