How to get other users' Namespaces?

[Greg Lovern]

I've written a VBA tool that gets the MAPI namespace of the Outlook
application, then gets the Calendar folder (olFolderCalendar) and the
appointment items in it, and creates a report in Excel based on those
appointment items.

Originally the idea was that each user would run it themselves at their
own computer, and the tool is working fine like that. But now I've been
asked to add the ability for a single user to run the report for other
users, at a single computer.

They are running Exchange 2003, and are able to view each others'
calendars. How do I get those other users' MAPI Namespaces? CDO? I
looked through MDSN's CDO reference, but I didn't see how to do it in
CDO. Can anyone point me in the right direction?


Many Thanks,

Greg Lovern
http://PrecisionCalc.com

 

[Greg Lovern]

I've just come across GetSharedDefaultFolder, which looks like it
should do what I want. But now I have a followup question:

This is for a very small organization of about 6 people. Instead of
requiring that they enter the names of the other users, can I get a
complete list of users who have Exchange defaultfolders, so I can
present the user with a dropdown list of all available names?


Thanks,

Greg Lovern