A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Calandaring
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Exporting Shared Calendar to Excel



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 15th 06, 03:32 PM posted to microsoft.public.outlook.calendaring
/Mike
external usenet poster
 
Posts: 2
Default 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



  #2  
Old February 15th 06, 04:00 PM posted to microsoft.public.outlook.calendaring
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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



  #3  
Old February 16th 06, 03:54 PM posted to microsoft.public.outlook.calendaring
/Mike
external usenet poster
 
Posts: 2
Default 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





  #4  
Old February 16th 06, 04:16 PM posted to microsoft.public.outlook.calendaring
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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





  #5  
Old March 16th 06, 09:34 PM posted to microsoft.public.outlook.calendaring
CliMan
external usenet poster
 
Posts: 1
Default 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






  #6  
Old March 16th 06, 10:25 PM posted to microsoft.public.outlook.calendaring
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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 news
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.


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
No more shared calendar Gregg Hill Outlook - General Queries 3 February 9th 06 05:17 AM
Outlook 2002: Opening appointment in Shared Calendar causes it to be copied into your own calendar QH Outlook - General Queries 1 February 3rd 06 02:45 PM
Outlook 2002: Opening appointment in Shared Calendar causes it to be copied into your own calendar QH Outlook - Calandaring 1 February 3rd 06 02:45 PM
Shared Calendar Sue Mosher [MVP-Outlook] Outlook - Calandaring 0 January 25th 06 07:26 PM
Exporting Contacts from Outlook emails don't go thru into Excel neilccarter Outlook - Using Contacts 1 January 18th 06 05:58 AM


All times are GMT +1. The time now is 11:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.