Macros

G

Guest

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.
 
S

Sue Mosher [MVP-Outlook]

It is not possible to filter views programmatically in Outlook 2000. That
feature was added in Outlook 2002 SP2.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Lou said:
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

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?
 
G

Guest

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 said:
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
View => Current View=> Customize Current View=> Filter ...... Advance
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
 
S

Sue Mosher [MVP-Outlook]

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.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Lou said:
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. That
feature was added in Outlook 2002 SP2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top