Merry Christmas everyone,

A manager in our organisation needs to see a report, created in Excel, which
is generated from some Outlook "contacts" fields. The difficulty is that
these Outlook "contacts" fields exist in another users account, which the
manager does have access to. The contacts are leads, which are only
applicable to this specific user and therefore can't be made public (there
are a lot of contacts).

So my question is this - is it possible to make a macro for the manager to
enumerate through another user's contacts in Outlook 2003, such that the
data can be read for the Excel report generation?

Any example code would be much appreciated, also!

Warm Regards,

Mike

You can use NameSpace.GetSharedDefaultFolder to get the other user's default
Contacts folder and then you can iterate it's Items collection. You must
create a Recipient object that is passed to the GetSharedDefaultFolder that
represents the store owner. See the Help in the Object Browser on that
method.

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


"Mike" . wrote in message ...
Merry Christmas everyone,

A manager in our organisation needs to see a report, created in Excel,
which is generated from some Outlook "contacts" fields. The difficulty is
that these Outlook "contacts" fields exist in another users account, which
the manager does have access to. The contacts are leads, which are only
applicable to this specific user and therefore can't be made public (there
are a lot of contacts).

So my question is this - is it possible to make a macro for the manager to
enumerate through another user's contacts in Outlook 2003, such that the
data can be read for the Excel report generation?

Any example code would be much appreciated, also!

Warm Regards,

Mike

Yes, you can use the Namespace.GetSharedDefaultFolder to return the other user's folder, assuming the manager has read permission on the folder.

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

"Mike" . wrote in message ...
Merry Christmas everyone,

A manager in our organisation needs to see a report, created in Excel, which
is generated from some Outlook "contacts" fields. The difficulty is that
these Outlook "contacts" fields exist in another users account, which the
manager does have access to. The contacts are leads, which are only
applicable to this specific user and therefore can't be made public (there
are a lot of contacts).

So my question is this - is it possible to make a macro for the manager to
enumerate through another user's contacts in Outlook 2003, such that the
data can be read for the Excel report generation?

Any example code would be much appreciated, also!

Warm Regards,

Mike

Thanks very much Ken & Sue,

Hope you both had a great New Year :-)

Mike