Import Calendar Event CSV File via Powershell to Room Resource Calendar

Hi Matt-Rolando,

to import a event to a Resource Mailbox (Room) form a CSV file with PowerShell, you can use this:

# Connect to Exchange Online
Connect-ExchangeOnline

# CSV File - Path to your file
$csvFilePath = "C:\Path\To\Your\File.csv"

# Your Room Resource Mailbox
$roomResource = "email address removed for privacy reasons"

# Import Calendar Event from CSV
$calendarEvents = Import-Csv $csvFilePath

foreach ($event in $calendarEvents) {
    $subject = $event.Subject
    $start = Get-Date $event.StartTime -Format "yyyy-MM-ddTHH:mm:ss"
    $end = Get-Date $event.EndTime -Format "yyyy-MM-ddTHH:mm:ss"

    # Create and Import Calendar Event
    New-ExoMailboxCalendarEvent -Mailbox $roomResource -Subject $subject -Start $start -End $end -Location $event.Location -Details $event.Description
}

# Disconnect from Exchange Online
Disconnect-ExchangeOnline -Confirm:$false