Quickly parsing items

  • Thread starter Thread starter Steve Parker
  • Start date Start date
S

Steve Parker

Hello,

I am trying to get a couple pieces of data from an outlook folder
quickly. I want to get a list of all the catagories of all the mail
items, and I want to get a list of all the people who have sent me
email. I can do this by iterating through each item and getting the
information, but this ends up running slow if I have a large number of
emails.

I noticed that when you modify a filter, there are statements that look
like SQL. For example, if you look at the message from last 7 days
filter you get...

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(%last7days("urn:schemas:httpmail:datereceived")%)

Looks like the items may be in some kind of database. Is there a way
to get a list of all senders and catagories quickly through vba? If so,
how

thanks
steve
 
Am 25 Aug 2005 10:01:22 -0700 schrieb Steve Parker:

Steve, the "database" is your *pst file.

You can use CDO instead of the OOM, which is very fast in iterating
through all items. CDO is an optional component on your Office CD.

After installing the Collaboration Data Objects you can set a refenrence
on it by checking "Microsoft CDO 1.21 library".
 
Back
Top