How to export a shared calender to CSV file

I have a shared calendar that a group uses and they need t exported to a CSV file. But when I start my outlook and open the shared calendar to export, export only shows my calendar that can be exported.

Is there a way to export the shared calendar?

running outlook 2013 and 2007
rdefinoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
regmigrantConnect With a Mentor Commented:
Apologies, EE wouldn't accept a .dotm file

Its a Word template, double click to start
OL-calendar-EE--2-.dot
0
 
regmigrantCommented:
The export functions in Outlook are fairly limited but the owner of the shared calendar (the person who set it up) should have no problem doing the export.

Alternatively - and much more flexible - you can use VBA as found in the My Outlook Calendar Template from Microsoft. This was originally distributed with Word 97 but works quite well today.

It has been greatly improved and modified by Michael Saye and his site is here:-
http://www.slipstick.com/outlook/calendar/idiots-guide-amending-outlook-calendar-template/

As defined it will use a word template to extract any calendar you have access to and display it in a nicely formatted word document.

If the CSV output is a requirement beyond this then let me have the following information and I can add a module to use Michael's code and put a CSV file out at the same time.

1. is weekly/monthly enough or do they want to choose a range of dates?
2. do they need to choose filenames or can I use a default path and name?
3. what level of detail is needed in the CSV (eg: start end time, subject, location, attendees, reminders, recurrence, all day events, etc etc)
0
 
rdefinoAuthor Commented:
Let's go for Jan - March 2014 and I need all events (all day or start & end time).  I don't believe the events have location or attendees so you can skip that part.  Mon - Sun - just in case.

Any filename

Thanks
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
regmigrantCommented:
Take a look at the attached macro enabled template - double clicking should start a new document and show a form (you may need to enable content).
Choose the calendar, start month and number of months to report

I've kept it simple to see if it's close to what you need - let me know what changes you might like to see

- it will create MyOlCal.csv on the desktop, overwriting any existing copy without warning
- it outputs start date/time, end date/time and subject only
- it uses US date format (mm/dd)
- it only works with the monthly calendars
- there are (existing) bugs in the template which mean you must select banners and print weekends - it makes no difference to the csv file

note that the majority of this code is copyright Michael Saye as noted above and in the code
0
 
rdefinoAuthor Commented:
cool , thanks.

One question, I don't see any attached file. :)

also, where do I open this file from? Outlook, word?
0
 
rdefinoAuthor Commented:
So I got an error, attached it.

I;m using word/outlook 2013 32bit.

I opened the shared calendar and made that the only one selected, ran the macro and got the error.
worderror.PNG
0
 
regmigrantCommented:
I can only get that error to appear if I do not have a calendar folder open in Outlook or outlook is closed and I ask for 'currently selected calendar'.

try it with an un-shared calendar first - the dialog box will show the current user's calendar at the top of the list, if that works then we can look at the shared one
0
 
rdefinoAuthor Commented:
I tried it against my own calendar and I get this error, attach files.
error1.PNG
error2.PNG
0
 
regmigrantCommented:
OK, that's a problem with creating the output file. I can't fix at the moment but will look at it later.

If you know any VBA at all you can check the following:-
Run it again and hit debug when the error appears then in the immediate window:-

type
debug.print cOutFile
it should show a filename with a path that points to your desktop
0
 
regmigrantCommented:
I used a standard method of finding and appropriate directory (the desktop) and creating the output file - did a CSV file appear on the desktop (it will be empty)?

To save messing about if you can give me the full path of where you want the output to appear I'll just incorporate that
0
 
rdefinoAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.