Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How to export a shared calender to CSV file

Posted on 2014-02-13
11
427 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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 300 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
In-place Upgrading Dirsync to Azure AD Connect
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

838 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