Exporting Shared Calendar to Excel

[/Mike]

Hello,

Running:
Exchange Standard 2003
Outlook Professional 2003
Full Administrator rights

I am trying to export a shared mailbox calendar or a public folder calendar
to Excel.
Here's what I'm doing:
In Outlook, File, Export & import, Export to a file, Microsoft Excel.
BUT!
The shared mailboxes or public folders do not appear in the export list. The
only thing I can export to Excel is my own calendar or a PST calendar ...

Is there any way of getting the shared calendars to show in the export list
?

Thanks,

Mike

 

[Sue Mosher [MVP-Outlook]]

Copy the folder to your mailbox and export from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[/Mike]

Sue,

Thanks for your answer.

Is there another way to do it ?

Thanks in advance,

Mike



Copy the folder to your mailbox and export from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sue Mosher [MVP-Outlook]]

Write code to accomplish the same thing programmatically.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Sue,
Do you have some sample code that can export data from a public folder
calendar?
If it would run on an Exchange server would be best, but if it runs on the
client I can live with that.
It would be greatly appriciated.

Thanks,
Bruce

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/customimport.htm for some general Outlook export samples.

To get a non-default folder to export form, you need to walk the folder hierarchy using the Folders collections or use a function that does that for you. See http://www.outlookcode.com/d/code/getfolder.htm and, especially for public folders, http://www.outlookcode.com/codedetail.aspx?id=1164

If you want to pursue Exchange methods, docs start at http://msdn.microsoft.com/exchange/
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers