Solved

How to export a shared calender to CSV file

Posted on 2014-02-13
11
407 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:rdefino
Comment Utility
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 300 total points
Comment Utility
Apologies, EE wouldn't accept a .dotm file

Its a Word template, double click to start
OL-calendar-EE--2-.dot
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:rdefino
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now