Amending Existing Code for Extracting Information from Outlook Folder

Hi all.

I recently received a solution to my question here:

http://www.excelforum.com/excel-prog...-a-folder.html

regarding looping through subfolders of a particular folder in my Outlook session and extracting certain information.

I now need to be able to do precisely the same operation, but this time the folder that I want to run the code on is not one of my default Outlook session folders, but rather a .pst file that I currently have open in Outlook via an external hard drive.

Here is the code that romperstomper kindly provided me with, which works great when the folder in question is one from my own Outlook session:

Please Login or Register  to view this content.

Can anyone tell me how to adjust the code to work for this case? I have tried amending the lines:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

to various things, but nothing seems to work.

Help appreciated as always.

Cheers

What does the top level folder name look like in the Outlook window with the .pst file loaded?

Not sure what you mean by "top-level", sorry.

My Navigation Pane appears to give "John.Doe@XMail.com" and the name of the .pst file I am accessing as being at the same "level" within the folder structure, though neither is a subfolder of the other.

Is that what you meant?

Regards

Did you replace the "John.Doe@XMail.com" in the code with the exact caption of the .pst file as it appears in the Outlook navigation pane?

Ouch. For some reason, no. I instead changed the Pst_Folder_Name to that...

Just tried what you said and works great.

Stupidity reigns supreme. Think it's time I picked up that manual!

Thanks a lot again!

Cheers

Glad to help.