I found some responses on different website but since they didn't fully work, I ended up patching some examples together to create the below vsb script which allows you to select any folder or archive in Outlook and then list out its subfolders to a text file.
Hope it helps, thanks Hasan.
dim loggit_logfilename, loggit_fso, loggit_silent
loggit_logfilename = ".\Outlook_Folder_List.log"
loggit_silent = true ' log file only or with MsgBox/Echo
set loggit_fso = CreateObject("Scripting.FileSystemObject")
Set objOutlook = CreateObject("Outlook.Application")
Set objNamespace = objOutlook.GetNamespace("MAPI")
Set olFolder = objNamespace.PickFolder
loggit "Selected Archive Name: " & olFolder.Name
loggit "Total Number of Sub Folders: " & olFolder.Folders.Count
GetSubfolders(olFolder)
Sub GetSubfolders(objParentFolder)
Set colFolders = objParentFolder.Folders
For Each objFolder in colFolders
Set objSubfolder = objParentFolder.Folders(objFolder.Name)
loggit objFolder.FolderPath
GetSubfolders objSubfolder
Next
End Sub
Wscript.Echo "Done. Log file created/appended at " & loggit_fso.GetParentFolderName(wscript.ScriptFullName) & "\Outlook_folder_list.org"
' From http://www.rgagnon.com/wshdetails/wsh-0003.html -=-=-=-=-=-=-=-=-=-
sub loggit (msg)
set stream = loggit_fso.OpenTextFile(loggit_logfilename, 8, True)
stream.writeline date & " " & time & ": " & msg
stream.close
if not loggit_silent then
WScript.echo msg
end if
end sub