Application.AdvancedSearch - namespace for Categories?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dawolfden@gmail.com - 26 Apr 2005 14:28 GMT

I'm modifying a VBA script which creates searchfolders from a
user-defined label to categories. I thought the namespace for that
filter would be urn:schemas-microsoft-com:office:office#Category but
this does nothing:

strFilter = "urn:schemas-microsoft-com:office:office#Category LIKE '%/"
& sqf & "/%'"

Any idea what the filter string would be to select on a specific
category?

Reply to this Message

Ken Slovak - [MVP - Outlook] - 26 Apr 2005 14:43 GMT

Use "urn:schemas-microsoft-com:office:office#Keywords".

The easiest trick to getting the property tag you need to use is by using
the customize current view dialog and the Filter button. In that dialog you
can set up your filter in the Advanced tab and then look at what was
generated in the SQL tab.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

> I'm modifying a VBA script which creates searchfolders from a
> user-defined label to categories. I thought the namespace for that
[quoted text clipped - 6 lines]
> Any idea what the filter string would be to select on a specific
> category?

Reply to this Message

Westbroek - 26 Apr 2005 15:07 GMT

Thanks Ken, excellent tip!

I must be off somewhere still. Using the following the searchfolder gets
created but returns no messages:

strFilter = "urn:schemas-microsoft-com:office:office#Keywords LIKE '%/"
& sqf & "/%'"

Set objSrch = Application.AdvancedSearch(strScope, strFilter, True,
strTag)

Does that look right?

> Use "urn:schemas-microsoft-com:office:office#Keywords".
>
> The easiest trick to getting the property tag you need to use is by using
> the customize current view dialog and the Filter button. In that dialog
> you can set up your filter in the Advanced tab and then look at what was
> generated in the SQL tab.

Reply to this Message

Ken Slovak - [MVP - Outlook] - 27 Apr 2005 15:18 GMT

I'd probably do it something like this:

strFilter = Chr(34) & "urn:schemas-microsoft-com:office:office#Keywords"
& Chr(34)
strFilter = strFilter & " LIKE '%/" & sqf & "/%'"

Your category is "/sqf/", where sqf is the value of that variable?

Signature

> Thanks Ken, excellent tip!
>
[quoted text clipped - 8 lines]
>
> Does that look right?

Reply to this Message