acantor Posted December 29, 2021 Report Share Posted December 29, 2021 Describe your best (or favourite, or most useful) Macro Express script you developed, or you started using, this past year. My favourite is a script I began last year, but only worked out the kinks recently. It's an application-specific script for Microsoft Outlook. The macro analyzes the body of the current email message, and decides which of about 20 folders to move the message into. The script doesn't actually move messages. Instead, it does everything up to the point of moving the message. If the macro guessed right, then I confirm by pressing Enter. At the core of the macro is a section of rules, e.g.: If Variable %Body% Contains "Mildred" Variable Set String %FolderPath% to "Mildred Smith" Macro Return End If If Variable %Body% Contains "George" AND If Variable %Body% Contains "Gratin" Variable Set String %FolderPath% to "George Q. Gratin" Macro Return End If etc. The script navigates through the tree-view in the "Move Items" window via two strategies: 1. When the focus is on a collapsed item in a tree-view, pressing Keypad * instantly expands every branch. 2. If you type quickly into an expanded tree-view, the focus will move directly to the item you typed. For example, in the "Move Items" window, you know there's a folder somewhere in the Inbox named "Mildred Smith"... 1. Navigate to the Inbox. 2. Press Numpad * to open every branch of the Inbox tree-view 3. Type "Mildred Smith" very quickly. Focus will be on the Mildred Smith folder. This macro saves me five or ten minutes per day. However, I confess that it might years to earn back the time saving, as I spent 20 or 30 hours to get the macro to work correctly and reliably! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.