Copilot to the Rescue: Weekly Review Emails

Your “boss” requires a weekly review by midnight Monday, but you have many things on your plate and want to maintain a healthy work-life balance.

Fortunately, you can rely on Copilot to complete reports quickly and accurately - Microsoft 365 Copilot or the Premium Copilot that is. If you use the consumer or business Copilot you would only get the format and fictional achievements in the draft because they do not have access to your data stored in Microsoft 365 (Exchange/Teams/OneDrive/…).

Let's cut the case, here is the prompt I created and tested:

Please draft an email with a paragraph of the summary, followed by top 5 achievements as bullet point as a weekly work review report for audit, using chats, e-mails and calendar events in my Outlook and Teams, and files created and modified in my OneDrive account last week. Hide any customer, personal and confidential information. Make it formal and professional.

You can also use the prompt below to get a detailed list of the activities you have done last week:

Please summarize my work from last week, utilizing chats, e-mails, and calendar events from my Outlook and Teams accounts, as well as files created and modified in my OneDrive account. Present the results in a tabular format with the following columns: Work, Description, Dates,Participants, and Outcome. Sort the table by dates.

Of course, it would be quite straightforward to modify the prompts for the work completed in the past two weeks, the previous month, etc. Additionally, you can incorporate extra SharePoint sites if required.

That’s all folks for today, happy piloting Copilot.