Gathering Calendar Appointments from Calendars that synced as Contacts

Status
Not open for further replies.

Nick Anderson

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
We have two companies that are merging together. During this merger we are sharing GAL and company A MIM synced their stuff over to company B. This sync caused all of the room calendars to come through in the Address Book as contacts. This is ok, but now I am needing to get data exported to Excel from these room calendars so that I can create a report.

Here is my question....I would like to know how to go about exporting data from all 9 room calendars from this company into Excel. I have tried doing a copy calendar and I am getting personal items error. I tried to change the view as a list, but that is not working either.

Not sure what else to try at this point, not sure if there is a PowerShell command that can be tested out.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Can you create a calendar folder and drag the events from the bad calendar to the new one? (That works for imported imap accounts with 'this computer only' folders).

I don't know it if will work for these folders, but you might be able to use mfcmapi to change the folder type.
Fix the Outlook Folder Type after Exporting an IMAP Account
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
J O365 - Adding Shared Google Calendar ICS link issue in O365 Using Outlook 0
B Outlook Calendar not coming down from cloud Using Outlook 2
J Time Zone Issues - Outlook Calendar and Webcal Feed Using Outlook 8
N Backing Up Exchange Calendar Using Outlook 13
N Having Shared Calendar shift to Current day Using Outlook 0
K UDF with formula not showing on Calendar custom view. Outlook VBA and Custom Forms 0
M In Outlook Calendar remove the buttons: 'Today' and '<' (Back a day) and '>' (Forward a day) that are below the Ribbon and above the calendar display. Using Outlook 0
U Macro for reminders,tasks,calendar Outlook VBA and Custom Forms 4
O Calendar - appointment templates and categories Using Outlook 1
HarvMan Outlook 365 Calendar Using Outlook 12
A calendar invites sent from Microsoft Outlook to Mac Outlook is not working Calendar Printing Assistant 3
P Categorize in Calendar not listed under tags in Office 365 (Office 2016) Using Outlook 5
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
J Weekend View in Calendar Using Outlook 1
D Add date next to day name in Outlook Today calendar view Using Outlook 1
A Birthdays from .csv to Calendar - arriving day behind Using Outlook 5
C Put Day of Year into Outlook Calendar Outlook VBA and Custom Forms 2
J can't sync outlook calendar contacts with iphone ipad Using Outlook 4
C Outlook Calendar Using Outlook 1
L Deleting Office 365 calendar appt w/o emailing invitees Using Outlook 3
sahameed82 SharePoint calendar directly open in Outlook Using Outlook 0
D Outlook 2016 Migrate 'On My Computer' (local storage) Calendar from Mac Outlook to Exchange Account Using Outlook 5
TomHuckstep Outlook 2016 Limit the number of days syncing from Google Calendar Using Outlook 1
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
Jennifer Murphy Add birthdays to calendar Using Outlook 7
M Creating an RSS Feed **FROM** Outlook 2013 Calendar. Using Outlook 5
K Accentuating today in Outlook calendar month view Using Outlook 2
S outlook 2007 calendar search Using Outlook 6
V iCloud calendar sync problems Using Outlook 13
J Copy to calendar function no longer working in outlook 365 Using Outlook 5
T why are the calendar icons different for different accounts Using Outlook 2
D Can Exchange Admin Center create a pst for users email/contacts/calendar? Exchange Server Administration 0
P OWA Settings->Calendar->Events from Email; Setting changes do not hold Using Outlook 1
W Outlook Calendar does not save view any longer! Using Outlook 3
M move to iCloud not working in outlook calendar Using Outlook 12
C Shading every other week on monthly calendar Using Outlook 4
cricket1001 Problems with calendar syncing Using Outlook 0
cricket1001 Shade non-working days in calendar Using Outlook 0
F My hotmail calendar is not syncing with my outlook but my email is Using Outlook 3
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
T Outlook 2010 Advice on syncing OL2010 Calendar and Outlook app Using Outlook 0
M Custom Calendar Print Suggestions? Using Outlook 0
L Time format in Outlook calendar and emails Using Outlook 0
GregS Simple calendar sharing doesn't work Using Outlook 6
P Strange Calendar Entries Using Outlook 4
W Looks like the folder below has been deleted: "iCloud\Calendar" Using Outlook 1
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
P How can I change my calendar view back Using Outlook 3
S Conditional Formatting in calendar part of To-Do Bar Using Outlook 1
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
Similar threads


















































Top