Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming Forms / May 2004

Tip: Looking for answers? Try searching our database.

Macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lou - 11 May 2004 02:51 GMT
We are using Outlook 2000 and have created a custom form which includes the fields "Date last contacted" and "Client Rating". The main use for these is that we can then create a report that shows all clients with a specific rating that have not been contacted for the last (say) 30 days

It is posible to manually filter by number of days and Client Rating by
View => Current View=> Customize Current View=> Filter ...... Advance

My question is this.
Is there a smarter/shorter way to do the same thing using macros - does anyone know of a macro that does some/most of what I am looking for
Thanks
Lou.
Sue Mosher [MVP-Outlook] - 11 May 2004 03:13 GMT
It is not possible to filter views programmatically in Outlook 2000. That
feature was added in Outlook 2002 SP2.

Signature

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

> We are using Outlook 2000 and have created a custom form which includes the fields "Date last contacted" and "Client Rating". The main use for these
is that we can then create a report that shows all clients with a specific
rating that have not been contacted for the last (say) 30 days.

> It is posible to manually filter by number of days and Client Rating by:
> View => Current View=> Customize Current View=> Filter ...... Advanced
[quoted text clipped - 3 lines]
> Thanks,
> Lou.
Lou - 11 May 2004 03:31 GMT
Sue

The majority of our PCs run Outlook 2000, but we do have 2 PCs running OL 2002 that we have access to.

How difficult is it to perform the filter programmatically

Lou
   
    ----- Sue Mosher [MVP-Outlook] wrote: ----
   
    It is not possible to filter views programmatically in Outlook 2000. Tha
    feature was added in Outlook 2002 SP2
   
    --
    Sue Mosher, Outlook MV
    Author o
         Microsoft Outlook Programming - Jumpstart fo
         Administrators, Power Users, and Developer
         http://www.outlookcode.com/jumpstart.asp
   
   
    "Lou" <loudp@riscpl.com> wrote in messag
    news:E4A9B932-0AD0-41A5-8A04-9B5C78F2E426@microsoft.com..
    > We are using Outlook 2000 and have created a custom form which include
    the fields "Date last contacted" and "Client Rating". The main use for thes
    is that we can then create a report that shows all clients with a specifi
    rating that have not been contacted for the last (say) 30 days
    >> It is posible to manually filter by number of days and Client Rating by
    > View => Current View=> Customize Current View=> Filter ...... Advance
    >> My question is this
    > Is there a smarter/shorter way to do the same thing using macros - doe
    anyone know of a macro that does some/most of what I am looking for
    > Thanks
    > Lou
Sue Mosher [MVP-Outlook] - 11 May 2004 12:15 GMT
How are your XML skills? In Outlook 2002, most of the view details are
exposed as the View.XML property. You need SP2 or later to work with the
<filter> element. The articles and samples at
http://msdn.microsoft.com/library/en-us/dnout2k2/html/odc_customviews.asp
and http://www.outlookcode.com/threads.aspx?forumid=4&messageid=19 provide
an overview, but nothing on filtering. Best way to understand the filters is
by example -- set up a filter you want, then look at its XML representation.

Signature

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

> Sue,
>
[quoted text clipped - 8 lines]
>      It is not possible to filter views programmatically in Outlook 2000. That
>      feature was added in Outlook 2002 SP2.

>      "Lou" <loudp@riscpl.com> wrote in message
>      news:E4A9B932-0AD0-41A5-8A04-9B5C78F2E426@microsoft.com...
[quoted text clipped - 9 lines]
>      > Thanks,
>      > Lou.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.