S
scabHead
Okay here is what I am trying to do and I have a workaround, I just want a
more elegant solution.
I have created a "To Do" search folder that shows draft emails, emails
flagged for follow up, and unread emails. However, I could not create a true
search folder to do this. I created a search folder that collected the draft
folders, my inbox, and my sent items into one big collection and then I
filtered the view using SQL in order to show the desired messages. It works,
however, I would rather the SQL be used to build the search folder, not
filter down the search folder.
So my question is this: is there a way to use SQL as the basis for a search
folder? If not, is there a way to add an OR condition using query builder to
check whether an email is read or not? I can't seem to find a query builder
"field" that will report whether an item is read or unread. SQL filtering
gives me that option, but I haven't seen a way to use SQL as the basis for a
search folder.
Lastly, I am using Outlook 2003 and the reason I am unhappy with the
workaround I just described is that I want the folder to report the filtered
count of items in brackets and not the count of unfiltered items. In other
words, my filtered view is likely to have a dozen or two messages in it, but
the bracketed count next to the folder name is going to list hundreds if not
more messages in it (a count which means nothing within the context I am
working).
(I hope this rant made sense)
more elegant solution.
I have created a "To Do" search folder that shows draft emails, emails
flagged for follow up, and unread emails. However, I could not create a true
search folder to do this. I created a search folder that collected the draft
folders, my inbox, and my sent items into one big collection and then I
filtered the view using SQL in order to show the desired messages. It works,
however, I would rather the SQL be used to build the search folder, not
filter down the search folder.
So my question is this: is there a way to use SQL as the basis for a search
folder? If not, is there a way to add an OR condition using query builder to
check whether an email is read or not? I can't seem to find a query builder
"field" that will report whether an item is read or unread. SQL filtering
gives me that option, but I haven't seen a way to use SQL as the basis for a
search folder.
Lastly, I am using Outlook 2003 and the reason I am unhappy with the
workaround I just described is that I want the folder to report the filtered
count of items in brackets and not the count of unfiltered items. In other
words, my filtered view is likely to have a dozen or two messages in it, but
the bracketed count next to the folder name is going to list hundreds if not
more messages in it (a count which means nothing within the context I am
working).
(I hope this rant made sense)