Export from Shared Outlook Calendar

Resolved · High Priority · Version 2007

Wed 30 Mar 2011, 13:40 Delegate Richard said...

Richard has attended:
No courses

Export from Shared Outlook Calendar

Is it possible to export information from a shared calendar in Outlook to an Excel file? If so, how?

Wed 30 Mar 2011, 15:41 Trainer Simon said...

RE: Export from Shared Outlook Calendar

Hi Richard,

Thank you for your question and welcome to the forum.

If you go to File and then Import and Export. Choose Export to a file.

Choose Comma Separated Values (DOS) for Microsoft Excel or Microsoft and then select the Microsoft Outlook calendar. Type in a name for the sheet.

I hope this answers your question.

Regards

Simon

Wed 30 Mar 2011, 16:20 Delegate Richard said...

RE: Export from Shared Outlook Calendar

Hi Simon

Thanks for your response.

I have tried following your steps, however the calendar I wish to export from is not in my mailbox and I am unable to select it on the list.

What are the steps in this case?

Regards
Richard

Thu 31 Mar 2011, 09:34 Trainer Simon said...

RE: Export from Shared Outlook Calendar

Hi Richard,

Thank you for your response.

I have just spoken to a colleague and he said that you could possibly attach the shared calendar to an email and then save the calendar file in a drive on your pc.

Maybe then try and use Import/Export and then choose the file. I will test it out this afternoon.

The alternative is to write some VBA code which would be beyond the scope of the forum.

Regards

Simon