Macro IntroThe existing Outlook Move button only displays 10 “Most Recently Used” (MRU) Folders. We have seen your calls for an expanded list of MRU Folders when using the Move button in Outlook. Well at Leverage & Lean we listen and let our programming do the talking! The Outlook Most Recently Used Folders Move Button macro allows you to control how many MRU Folders you see! This macro watches a specified Inbox and tracks when items are moved to its Subfolders. The usage is tracked into an Excel Workbook to build your own “Most Recently Used” Move Folders registry. This Outlook macro will track and increase the folder usage by 1 (per item) moved to that Folder. This will give a clear picture of not just what the MRU folders are in Outlook but how many items are being moved to them over time. The more you use this macro the clearer picture it will have of your usage. If you create a NEW Folder in Outlook this macro is designed to add to the bottom of you MRU Folder list and start tracking your usage. This usage information is referenced when using this Outlook Move macro to display the MRU Folder options. To move items to just enter the leading number in front of the Outlook Folder name.
This Outlook VBA code is separated into two parts and requires an Excel Workbook to reference. (Here is an Excel Workbook template to use)
1. Tracking the usage of the Outlook Folders items are being moved to. This code needs to be copied and pasted into the ThisOutlookSession folder of Visual Basic. Within this segment of code, you need to indicate which Inbox you want this macro to be watching. This is easiest if you only have one Outlook Account setup as the macro will look to this Account by Default. If you have multiple Outlook Accounts to choose from it is important to ensure the Account, you want to watch is the Default Account or the VBA code is updated to reflect the specific Account Email Address. Once this code is setup you won’t need to interact with it again. Outlook will continue to watch the Inbox and Subfolder usage supplying an Excel Workbook with the appropriate options for the second part of this code.
2. This is the Move Custom button VBA code. Using the same Excel Workbook with the Subfolder usage this code will sort the Folder usage by Largest to Smallest. Working from the most used this Outlook macro will populate two columns of folder options an InputBox. You can choose how many folders display in each column but keep an eye on exceeding the 1024-character limit. To have more options try to keep your Subfolder names short and concise. Once the InputBox displays type the leading number of the MRU Folder you want to select. Once a selection is made this Outlook macro will move all selected items to the folder.