A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

AdvancedSearch Filter Syntax for Advanced Date Search on Appointme



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 20th 07, 12:14 PM posted to microsoft.public.outlook.program_vba
StephenCarterMCP
external usenet poster
 
Posts: 1
Default AdvancedSearch Filter Syntax for Advanced Date Search on Appointme

I am trying to create a tool to select all appointments that exist, begin or
end within a specific time frame. I have searched the KB, the web and now
these newsgroups and no where does there seem to be any examples of how to
create the AdvancedSearch filter syntax for anything but email. They also are
limited to one field searches.

All of the examples for creating the filter string I've seen start with
"urn:schemas:httpmail:subject" But what do I use for appointments? Where do I
find a list of available schemas? Also what is the syntax for creating
multiple criteria using the End, Start, and Recurrence properties?

Any help would be most appreciated.

Thanks
Ads
  #2  
Old February 20th 07, 01:19 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default AdvancedSearch Filter Syntax for Advanced Date Search on Appointme

The easiest way to answer these questions is to create a filtered view that shows you the data you're interested in and then look at the SQL tab of the View dialog to get the DASL query string. For complex queries, a query builder is available. See http://www.outlook-tips.net/archives/2004/20040927.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"StephenCarterMCP" wrote in message ...
I am trying to create a tool to select all appointments that exist, begin or
end within a specific time frame. I have searched the KB, the web and now
these newsgroups and no where does there seem to be any examples of how to
create the AdvancedSearch filter syntax for anything but email. They also are
limited to one field searches.

All of the examples for creating the filter string I've seen start with
"urn:schemas:httpmail:subject" But what do I use for appointments? Where do I
find a list of available schemas? Also what is the syntax for creating
multiple criteria using the End, Start, and Recurrence properties?

Any help would be most appreciated.

Thanks

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
save advanced search smokiibear Outlook - General Queries 4 March 22nd 07 12:27 AM
Filter/Schema to use for AdvancedSearch of Drap/Drop Files EricTempPA Outlook and VBA 0 June 29th 06 09:24 PM
Advanced filter view Richard Edwards Outlook - General Queries 0 March 9th 06 12:13 PM
Advanced filter view Richard Edwards Outlook - Using Forms 0 March 9th 06 12:13 PM
AdvancedSearch filter: cannot search "to" by smtpaddress? Sue Mosher [MVP-Outlook] Outlook and VBA 1 February 9th 06 07:04 PM


All times are GMT +1. The time now is 12:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.