Solved

Export Outlook Calendar to Excel

Posted on 2014-01-15
1
1,867 Views
Last Modified: 2014-01-16
Is there a way to export a calendar from outlook to excel using VBA and have it take the "categories" that are color coded with the export? I want to be able to export all the meetings on a calendar into excel but have it take the categories and color codes that go along with it and also be able to computer the total duration of the meetings on the calendar as well. Can this be done in VBA where you can just run a macro in outlook and have it dump all this into excel?
0
Comment
Question by:Lawrence Salvucci
1 Comment
 
LVL 12

Accepted Solution

by:
Md. Mojahid earned 500 total points
ID: 39784829
In O'2010 - there are two ways to get to the same place
Method 1 --> File --> Open --> Import (opens import/export wizard)
Method 2 --> File --> Options --> Advanced --> Export (opens import/export wizard)
Once there - simply follow the screens accordingly. When the MAP CUSTOM FIELDS button appears, you may want to check all the fields that will exported in the event that you don't want them all.
 
http://www.extendoffice.com/documents/outlook/1164-outlook-export-calendar-to-excel.html
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

895 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

15 Experts available now in Live!

Get 1:1 Help Now