Doing more with Outlook filter and SQL DASL syntax

re: Doing more with Outlook filter and SQL DASL syntax

Pet — Sat, 21 May 2005 14:23:56 GMT

Hi,

Tried to find a way (sql filter) to only show emails (and journal items, like phone calls and documents done) which are older than i.e. 3 months (accepting to put the actual date minus 3 month). Could not manage it. The idea behind is to know the contacts, where last contact is older than i.e. 3 month.

Any solution would be great - Thanks Pet
PS: E-mail items would refer to SENT DATE;
Journal items to START Date
PPS: Already would be happy if only the SENT DATE would work ...

re: Doing more with Outlook filter and SQL DASL syntax

Harry — Wed, 01 Jun 2005 15:20:40 GMT

Great article, I've been searching high and low for something like this article. Anyone tried to use this to look at more than just the current message?

What I would really like is to be able to show all conversations that contain an unread message. In pseudo-sql this would be a filter 'WHERE subject in (select subject from folder where not read)'.

Cheers,

Harry ( hjb _symbol_ null.net)

Outlook Filter & SQL

Dirks WebLog — Tue, 26 Jul 2005 19:05:19 GMT

Ich bin schier sprachlos... Outlook ist ja manchmal zugegebenermaßen ein schwer zu reitendes Pony und...

Outlook SQL DASL syntax - an update

Andrew Delin's WebLog — Mon, 08 Aug 2005 09:23:21 GMT

Here's an update to my previous blog entry on Outlook SQL DASL syntax.
I had some great feedback from...

links for 2007-06-18 | IndianGeek

links for 2007-06-18 | IndianGeek — Tue, 19 Jun 2007 02:20:12 GMT

PingBack from http://www.indiangeek.net/?p=194

Chronicles of a Catholic Geek » Blog Archive » GTD and Outlook Views

Chronicles of a Catholic Geek » Blog Archive » GTD and Outlook Views — Fri, 29 Jun 2007 19:27:44 GMT

PingBack from http://catholicgeek.stblogs.com/2007/06/29/gtd-and-outlook-views/

Re: Customized Outlook Conversations View

Channel 10 — Tue, 17 Jul 2007 16:34:03 GMT

FYI: To get the filter button (isn't on the tool bar by default and right-clicking a search folder doesn't show the SQL tab in Outlook 2007) folow these steps on