• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

Getting Outlook to Find and Jump to a Folder in Folder List

I have been using the excellent work of  chris_bottomley to iterate through the Outlook folder list to find a folder:


I am wondering if someone can help me adapt this macro slightly to do the following:

1) In the current macro, once the folder is found, the folder list jumps to that spot. That found folder is highlighted, but if it is too far down (or up) in the list, it is not visible in the folder list and I have to scroll to it. I would like it to both find and jump to be visible on the screen.
2) Instead of displaying the messages in the now found folder, as the macro does now, I would like to keep the messages displayed that were visible when the macro was called. This would allow me to easily copy some of these messages to the found folder which is now visible on the left.

I would be grateful for anyone that can show me how to adapt the macro code in the link above to do these things differently.

1 Solution
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I recommend to replace line 31:
  Set olApp.ActiveExplorer.CurrentFolder = tgtFolder
That will open a new Outlook Explorer window. Only con is that you need to close that window if unwanted, as the loop will open a new window for each go. But your current folder will not change, and the new Explorer will scroll to the correct folder in the list and show the content of it.
KenHadleyAuthor Commented:
Yes, thank you, that works.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now