Programmatic construction (macro) to make complex views on the fly

I really feel that the ability to specify filters in SQL is truly an enabling
feature in Outlook. My way of organizing tens of thousands of emails is to
actually leave them in one big folder (I start a new one each year), and to
use categories as tags. Categories is really a nice field because you can
assign multiple ones per message. I expose this field and sort by it in
message view, and it blows away (to me) the notion of making many neat little
folders and trying to figure out which one a message should go into (or
copying it multiple times into multiple folders). It's a real power method
for organizing messages, cause you can easily change, consolidate, and tweak
the categories of multiple messages very quickly. Imagine trying to do this
with folders, where you can really only see into them one folder at a time.

Often, even in this method, I need to narrow down my search. I can still
find > 1000 messages having a specific category, which I can sometimes deal
with by employing a secondary grouping, but I cannot sadly group by
categories within a grouping by categories (too much recursion I guess). Say
I want to find things having two categories, "NPS" and "AMES". I only have
one message with both categories, but I have > 500 messages that have NPS and
700 messages that have AMES. With the ability to customize a filter in
views using SQL, I can do something like this:

("urn:schemas-microsoft-com:office:office#Keywords" LIKE '%NPS%' AND
"urn:schemas-microsoft-com:office:office#Keywords" LIKE '%AMES%')

and this prunes away the clutter very quickly to the single one message that
related to both those category tags. In fact, that is the only way I can
quickly find those intersections.

SORRY FOR THE LONG PREAMBLE, but this is my zillion dollar question: Can we
use macros to define view filters on the fly? Instead of having to clumsily
click through a bunch of stuff to get to the filter dialog and type it in,
I'd like to get to the point of having quick-select macros that can help me
find things in a flash. No more clicking through pigeon-holed folders, I
can't go back at this point.

-jim
.

Relevant Pages

  • RE: Programmatic construction (macro) to make complex views on the
    ... Sue Mosher, Outlook MVP ... copying it multiple times into multiple folders). ... use macros to define view filters on the fly? ...
    (microsoft.public.outlook.program_vba)
  • RE: Programmatic construction (macro) to make complex views on the fly
    ... you should always include when posting to an Outlook forum. ... copying it multiple times into multiple folders). ... use macros to define view filters on the fly? ...
    (microsoft.public.outlook.program_vba)
  • Re: Which folders are shortcuts?
    ... Mike maybe you should take the time to explain what you are talking about. ... > for what appears to be multiple entries.. ... > Some of the folders are 'system protected' and for good reason.. ... > computer illiterates download stuff and don't know where its gone, ...
    (microsoft.public.windowsxp.basics)
  • Re: Single Front End File with Form that Can by Filtered By User
    ... their own copy) with a single instance of each form. ... users (using filters, etc) I now realize I've created a maintenance ... a FE doesn't lock multiple users ... Can I create one form in one front-end that is shared ...
    (microsoft.public.access.forms)
  • Re: DirectShow Crashes upon IMediaControl::Stop intermittently
    ... >>>using doesn't support multiple simultaneous instances. ... What is the AVI ... The other filters are all stock: ... there's no problem running multiple simultaneous graphs. ...
    (microsoft.public.win32.programmer.directx.video)
Loading