Read time 5 min
Businesses, for successful execution of their projects, conduct meetings and communicate their ideas and strategies. That’s why the managers plan meetings using calendar applications and share it with the others. But sometimes, the managers many need to have an offline copy of the calendar events to share with some other users or clients.
So, you need to export the calendar items from Office 365 and you can do it using the PowerShell cmdlets easily.
Outlook includes a 'Using Outlook with Voiceover' article on the main presentation screen. The article begins with a summary of VoiceOver, then offers detailed descriptions on how to accomplish various Outlook tasks, such as composing or replying to an e-mail, or entering an Outlook calendar event. Export contacts from Outlook to a CSV file or Excel. Export email, contacts, and calendar to a PST file. Import to Outlook app. Import email and contacts to Outlook 2016 for Mac. Import a Windows PST file into Outlook 2016 for Mac. Export from Outlook app. Export items to an archive file in Outlook for Mac. To link your Microsoft account calendar, launch the Alexa app on your Android or iOS device or the web at alexa.amazon.com. Log in and head to Settings Calendar. On the next screen, tap or click.
- Create a network-shared folder to save the PST file.
- The users account should have the read/write permissions to the Exchange Trusted Subsystem group on the folder.
Now start the process –
- Run the following command that will let you any kind of script whether it is signed or not. It will ask you to confirm your selection related to the change in execution policy. Click YSet-ExecutionPolicy Unrestricted
- Run the second command to input the credentials of Office 365 account.
- A pop-up will open and ask you to input the credentials of office 365 account.
- you need to create a session with the Office 365. run the below command –$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri
https://outlook.office365.csom/powershell-liveid/ -Credential $UserCredential –
Authentication Basic –AllowRedirection - It will again ask you to input the credentials of your Office 365 account.
- When the Powershell is connected with the Office 365 complelely, then you can import the whole session by running the following command;
- In last, you can run the cmdlet to export the entire calendar folder ot export the data within the range.New-MailboxExportRequest –Mailbox -IncludeFolders ‘Calendars’ –FilePath ‘D:Meeting RoomAdam.pst’
OrExport-Mailbox-Identity –StartDate ‘22/06/2016’ –EndDate ‘16/09/2017’ –IncludeFolders ‘Calendar’ –FilePath PSTFileFolderNameFileName.pst
Import calendar into the Office 365 mailbox
If you have a CSV file with the important calendar events, then you can import the CSV file into the Office 365 mailbox by following the steps;
Calendar Microsoft Template
- Install the EWS Managed API from the below URL –
https://www.microsoft.com/en-us/download/details.aspx?id=35371 - Assign Impersonation Rights to the account.
- Create the CSV file having all the fields like Date, Subject, Start Date, End Date, Start Time, and End Time.
- Now, run the command;Import-CalendarCSV -CSVFileName D:Monthly Meetingscalendar.csv -EmailAddress
jacob@domain.com -Impersonate $true - If the account does not have the impersonation rights, then you can run another command;Import-CalendarCSV -CSVFileName D:Monthly Meetingscalendar.csv -EmailAddress
jacob@domain.com -username jacob@domain.com -password 1234!@#$
Limitations of the manual import/export
Export Calendar Microsoft Outlook 16.9 2019
- The manual methods do not let you apply filters easily in the calendar items.
- You need to create a CSV file for importing the calendar items, which may be time-consuming.
- You can export or import the calendar items of the single mailbox only that maybe not enough for a large project.
- If any field in the CSV file is missing, then there is no way to skip it.
- The account should have impersonation rights while importing the data.
- If the session is stopped abruptly during the export, then you will have to start the export process again. It may also corrupt the PST file.
- There can be some errors in the Mailbox Export Request Access path is denied.
Conclusion
To overcome the limitations of the manual import/export method, you should use the Kernel Office 365 Backup & Restore tool. This software lets you take the selective backup of unlimited mailboxes and restore multiple PST files to multiple Office 365 mailboxes. The Office 365 Backup & Restore tool gives you the flexibility of choosing any folder from the mailbox, apply filters to it, and save it in the PST file. There is no limitation on the number of mailboxes for taking the backup and the tool will save a separate PST file for each mailbox.
Similarly, you can import the entire PST file or its chosen folders into the Office 365 mailbox. After the completion of import/export, you will get a complete migration report with the status of each migrated item. You can also save the migration report in a CSV file.