[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How to export a shared calender to CSV file

Posted on 2014-02-13
11
Medium Priority
?
634 Views
Last Modified: 2014-02-25
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
0
Comment
Question by:rdefino
  • 6
  • 5
11 Comments
 
LVL 19

Expert Comment

by:regmigrant
ID: 39856671
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
 

Author Comment

by:rdefino
ID: 39856906
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
 
LVL 19

Expert Comment

by:regmigrant
ID: 39857735
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
Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

 

Author Comment

by:rdefino
ID: 39857742
cool , thanks.

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

also, where do I open this file from? Outlook, word?
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 1200 total points
ID: 39857744
Apologies, EE wouldn't accept a .dotm file

Its a Word template, double click to start
OL-calendar-EE--2-.dot
0
 

Author Comment

by:rdefino
ID: 39857762
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
 
LVL 19

Expert Comment

by:regmigrant
ID: 39858291
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
 

Author Comment

by:rdefino
ID: 39859004
I tried it against my own calendar and I get this error, attach files.
error1.PNG
error2.PNG
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39859106
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
 
LVL 19

Expert Comment

by:regmigrant
ID: 39861204
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
 

Author Closing Comment

by:rdefino
ID: 39886628
Thanks!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
Often, the users face difficulty in accessing Outlook 2016 PST files on Windows 10 computer. One of the reasons behind it is the improper functioning of MS Outlook when the user tries to open it. MS Outlook suddenly stops working, or it will not op…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question