Automate·Beginner·15 min·Updated Sep 30, 2026

Delegate a weekly status report to Copilot Cowork

Set up a recurring "Monday status report" task that Copilot Cowork runs end-to-end each week instead of someone compiling it by hand.

Download PDF

Microsoft 365

Works With

Business Outcome

A consistent weekly status update produced on schedule without taking up someone's Monday morning.

Workflow Overview

The apps run in this order.

Outlook
Teams
Copilot Cowork

Step 1: Define the recurring task onceCopilot Cowork

Write the brief for what the weekly report should cover — project status changes, blockers raised in Teams, upcoming deadlines — and where it should be delivered (a Teams channel post, an Outlook email to the team).

Step 2: Set the recurrenceCopilot Cowork

Configure the task to run automatically on the same day and time each week, so it becomes a standing deliverable rather than something you have to remember to trigger.

Prompt idea:

Every Monday at 8am, compile a status update from the project tracker's changes this past week, any blockers flagged in the team Teams channel, and deadlines coming up in the next 7 days. Post it to the Project Updates channel.

Step 3: Spot-check the first few runs closelyTeamsOutlook

Review the first 2-3 automated reports in detail before trusting the cadence unattended — this is where you catch a misread source or a formatting issue before it becomes a weekly habit.

Step 4: Adjust the brief as the project evolvesCopilot Cowork

Open the recurring task's configuration whenever a source changes — a tracker migrates to a new tool, the team moves to a different channel — and update the brief immediately rather than waiting for someone to notice the report quietly stopped reflecting reality.

Check the work

  • Compare a sample week's report against the actual source data (tracker, channel messages) to confirm nothing was missed or misstated.
  • Confirm blockers reported as "unresolved" are actually still open, not something already closed since the report ran.
  • Check the delivery channel occasionally to make sure the recurring post is actually landing, not silently failing.

Inspired by: Microsoft, Copilot Cowork blog, 2026.

Expected Outcome

A weekly status update delivered to the team on a set schedule, pulled from the same sources every time.

✓

AI is the right call here

Listing deadlines in the next 7 days is a date filter. Reading what was actually flagged as a blocker in Teams chat, versus just discussed, is the part that needs language understanding.

Related Workflows

Related Playgrounds

WORK WITH LIMINALS

Make AI useful for your team.

Get practical help with AI consulting or ask about training courses for your team.