If you find that your Outlook macros run slow, your code may benefit from using filters to limit the number of items being processed by a loop.
Continue Reading »
filter
Finding values in an array without looping
If you need to find a value in an array, you might be inclined to loop through the array and using a function like Instr to match each value in the array against the selected value to see if it exists.
Until recently, I would have done the same thing (breaking it out into its own function, of course). But recently I discovered another way to do it that doesn't require looping, and thought I'd share.
Follow Me