How I Created 30 Demo Emails for a Copilot Scheduled Prompt

A Copilot demo is only as good as the data it has to work with. I wanted to demonstrate a scheduled prompt that reviews the previous seven days of email, identifies anything urgent, extracts actions and lessons learned, and prepares a Monday morning update for a team. There was one fairly obvious problem: I needed a mailbox full of realistic emails first. Rather than manually creating 30 messages, changing their dates and trying to remember which ones should be unread or important, I built a reusable PowerShell utility that creates the demo data through Microsoft Graph. The result was a mailbox containing 30 synthetic emails spread across seven days, ready for Copilot to summarise. ...

16 August 2026 · 8 min · DamoBird365