Exporting Shared Calendar to Excel
 

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

Exporting Shared Calendar to Excel
 

Copy the folder to your mailbox and export from there.

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

Exporting Shared Calendar to Excel
 

Sue,

Thanks for your answer.

Is there another way to do it ?

Thanks in advance,

Mike



"Sue Mosher [MVP-Outlook]" wrote in message
...
Copy the folder to your mailbox and export from there.

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

Exporting Shared Calendar to Excel
 

Write code to accomplish the same thing programmatically.

--
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 ...
Sue,

Thanks for your answer.

Is there another way to do it ?

Thanks in advance,

Mike



"Sue Mosher [MVP-Outlook]" wrote in message
...
Copy the folder to your mailbox and export from there.

"/Mike" wrote in message
...
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

Exporting Shared Calendar to Excel
 

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]" wrote:

Write code to accomplish the same thing programmatically.

--
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 ...
Sue,

Thanks for your answer.

Is there another way to do it ?

Thanks in advance,

Mike



"Sue Mosher [MVP-Outlook]" wrote in message
...
Copy the folder to your mailbox and export from there.

"/Mike" wrote in message
...
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

Exporting Shared Calendar to Excel
 

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"CliMan" wrote in message ...
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.