Copilot Cowork Figured Out a Complex Mail Merge

Use Microsoft Copilot Cowork to match files in a OneDrive folder to the right people, draft personalized Outlook emails with different attachments, and send them after you approve. Tested with 3 people and 6 files, then 48 people and 96 files.

Share
Copilot Cowork Figured Out a Complex Mail Merge

Can Copilot Cowork look in a folder full of files, figure out which files belong to which person, build an Outlook mail merge that attaches different files to different people, let me check it, and then send everything out? I tested it with a OneDrive folder, and it did all of that with very little help from me.

This is the full walkthrough of the test I wrote about in 6 Files. 3 People. Can Copilot Cowork Figure It Out? I'll show you the prompt I used, what Cowork did with three people and six files, and what happened when I scaled it up to 48 people and 96 files.

The files in OneDrive

I created a folder in my OneDrive called _Conf_Files_cowork. Every file in it is fictitious. There is a conference schedule for Carol, one for Chris, and one for Cristian, plus an expense guidelines document for each of them.

OneDrive folder named _Conf_Files_cowork containing three conference schedule PDFs and three expense guideline PDFs
The OneDrive folder: a conference schedule and an expense guidelines PDF for each of three people.

Each PDF has the person's name in the filename and inside the document, like "Prepared for Carol Wilson." What the files don't have is an email address. Cowork has to work that part out on its own.

Conference Schedule PDF prepared for Carol Wilson, showing session times and locations
Each PDF has the person's name in the filename and inside the document, but no email address.

I took a screenshot of the OneDrive folder. I wanted to see if Cowork could find the folder location from just a screenshot, without me having to go get a link.

Open Cowork (and know about the credits)

In Microsoft Copilot, click the Cowork tab in the top left, next to Chat and Code.

Microsoft Copilot with the Cowork tab selected next to Chat and Code, showing the Where should we start today prompt box
Cowork is its own tab in Microsoft Copilot, between Chat and Code.

Before you try this: Cowork uses usage-based billing (UBB). It costs money on top of your Copilot license. If Cowork isn't working for you, you will probably need to request credits, and your admin has to assign them. I explain the new billing model in Home, Chat, Cowork, Code, USL & UBB Explained.

Let Cowork find the OneDrive folder from a screenshot

I pasted the screenshot and asked one simple question: "Can you figure out what OneDrive folder this is? I'm going to use it."

Cowork found the folder and came back with the folder name, where it sits in my OneDrive, and the six PDFs. It even organized them into conference schedules and expense guidelines. I didn't ask it to do that.

Cowork reply identifying the _Conf_Files_cowork OneDrive folder from a screenshot and listing the six PDFs by type
From nothing but a screenshot, Cowork found the folder and organized the six files into schedules and expense guidelines.

Write the mail merge prompt

The thing that makes this an advanced mail merge is that one person can get multiple attachments. Cowork has to go into the OneDrive folder and find the right files for each person. Here is what my prompt asked for:

  • Review all the PDFs in the OneDrive folder and work out which files belong to which person, based on the filenames and the information inside the PDFs.
  • Prepare one separate email for each person and attach only the PDFs meant for that person.
  • Use my email address for me. For everyone else, find the right person in my organization and use their work email. If there is more than one possible match, stop and ask me.
  • Use the subject "Your Conference Documents."
Cowork prompt asking it to review the PDFs in the OneDrive folder, match files to people, and prepare one email per person
The first half of my prompt: match the files to people, one email per person, and find their work email addresses.

Then I gave it the message. Because Cowork knows each person's name, I could start with "Hi [First Name]."

Hi [First Name],
Attached are your conference documents.
Thanks,
Chris

The last line of the prompt is the important one: before sending anything, show me each recipient, the email address you selected, and the files you intend to attach. Wait for my approval before sending.

Second half of the Cowork prompt with the Hi First Name message and an instruction to wait for approval before sending
The second half: the message with a Hi [First Name] greeting, and a request to show me everything before sending.

All of the email addresses in this test were mine, so it was all internal. I've blurred them out in these screenshots.

Review the recipients and attachments

Cowork read all six PDFs and came back with a table: each recipient, the email address it picked, and the files it planned to attach. It also told me how it chose the work addresses. For example, there was only one Carol Wilson in my organization. It had this correct, and nothing had been sent yet.

Cowork table listing Chris Menard, Carol Wilson, and Cristian Cotovan with blurred email addresses and the two PDFs each will receive
Cowork shows each recipient, the email address it chose, and the files it plans to attach. Nothing has been sent yet.

Cowork asked me to reply "approved" to send the three emails, so that's what I typed.

Approve and send each email

Each email shows up as a draft card with the subject "Your Conference Documents" and the "Hi, first name" greeting. A few things to know here:

  • Every email ends with Sent by Copilot Cowork. I asked Cowork if it could remove that line, and the answer was no. It doesn't bother me.
  • You may see an External recipients warning. In my case, the external recipient was me, so that was fine.
  • You can click Send on each email one at a time, click Approve All (3), or use the drop-down for Approve All (3) & don't ask again.
Cowork Send email card with the subject Your Conference Documents and the Approve All (3) and don't ask again option open
Each email shows up as a draft. You can send them one at a time or use Approve All.

I sent mine one at a time so I could check each one. You could approve all three at once.

Check the sent emails in Outlook

Over in Outlook, my Sent Items had all three emails, to Cristian, Carol, and Chris, each with two PDFs attached. The test worked.

Outlook Sent Items showing three Your Conference Documents emails to Cristian Cotovan, Carol Wilson, and Chris Menard, each with two attachments
All three emails in my Outlook Sent Items, each with two PDF attachments.

Check how many credits the task used

Here's a quick trick. In Cowork, type /cost and press Enter. Cowork tells you how many credits the task used. This one used 40 credits. 100 credits is $1, so this mail merge cost less than a dollar.

Cowork response to the /cost command showing 40 credits used for this task
Type /cost in Cowork to see how many credits the task used. This one used 40 credits.

Compared with Power Automate

I have done this before with Power Automate, and it worked, but it took a lot more effort. I had to build an Excel file with everyone's email address, and put the URL of every file each person needed on a separate line. With Cowork, I gave it a folder and a prompt. If you prefer the classic approach, my Excel, Word, and Outlook mail merge still works for personalized emails, but it doesn't handle different attachments for each person.

Scale it up: 48 people and 96 files

Honestly, with three people and six files I could have just sent the emails myself. So I made the test harder. I created 48 new fictitious recipients and 96 PDF files that needed to go to them. Names are in column B and emails in column C. Every address uses example.com, a domain reserved for documentation by the Internet Assigned Numbers Authority (IANA), so nobody can own it.

Excel master list with full names, fictitious example.com email addresses, file counts, and up to three PDF filenames per person
My master list for the bigger test: 48 people with fictitious example.com addresses and the PDFs each one should get. Cowork never saw this file.

This Excel file matches all 48 people to their 96 files. Uploading it to Cowork would have been unfair, because the answer is already in it. So I only gave Cowork the names and email addresses.

The 96 new files went into the same OneDrive folder. Select everything and you can see there are 102 files: the six from the first test plus the 96 new ones.

OneDrive _Conf_Files_cowork folder with 102 files selected, including conference schedules for many new people
Same OneDrive folder, now with 102 files: the original six plus 96 new PDFs.

Run the larger test in Cowork

I went back to the same Cowork task and added this prompt, then pasted the 48 names and emails below it:

In the same OneDrive folder we've been using, I have added 96 additional files. They need to go out to multiple people. I'm going to paste down below their names and emails. Match them up and show me the match-up first. If you have any questions, let me know.
Cowork prompt saying 96 additional files were added to the same OneDrive folder, followed by Cowork's reply that it read all 96 files
My second prompt, with the 48 names and emails pasted below it, and the start of Cowork's reply.

When Cowork finished, it had read all 96 files and nothing had been sent. It found three kinds of documents: a conference schedule, expense guidelines, and a travel checklist. It also worked out the combinations:

  • 16 people get all three documents.
  • 16 people get the expense guidelines and travel checklist only.
  • 16 people get the conference schedule only.
Cowork summary explaining three document types and that 16 people get all three, 16 get two, and 16 get only the schedule
Cowork found three document types and worked out that 16 people get each combination.

Verify the matches against the master list

To prove it was right, I went back to my master Excel file. Files per person: 1, 2, and 3, with 16 people in each group. That is exactly what Cowork came up with, and it never had access to this file. It only had names and emails.

Excel summary sheet showing 48 recipients, 96 PDF files, and 16 people each receiving one, two, or three files
The master list agrees: 16 people get one file, 16 get two, and 16 get three.

Back in Cowork, all 48 people are listed with their email and the files they're getting. Cowork also pointed out that three people share the last name Bennett, so it kept their files and addresses separate. It left the six files from the first test alone because those had already been sent. Then it asked if it should send them with the same subject and message as before.

End of Cowork's 48-person match list, with notes about three people sharing the last name Bennett and a question about sending
The end of the 48-person list. Cowork even noticed that three people share the last name Bennett and kept their files separate.

The answer would be yes. Because these are fictitious addresses, I didn't send them, but the first test already showed the sending part works.

Quick recap

  • Cowork can find a OneDrive folder from a screenshot.
  • Describe what belongs in each email, give it the message with a "Hi [First Name]" greeting, and tell it to show you everything and wait for your approval before sending.
  • Review the recipients, addresses, and attachments, then send one at a time or use Approve All.
  • Type /cost to see how many credits the task used. 100 credits is $1.
  • With only names and emails, Cowork matched 96 files to 48 people correctly. No lookup spreadsheet, no Power Automate flow.

This is a great example of when you'd use Microsoft Copilot Cowork. If you have any questions, please put them in the comments. Thank you for your time.

6 Files. 3 People. Can Copilot Cowork Figure It Out? (Update: 51 Users, 102 Files)
I initially gave Microsoft Copilot Cowork six PDFs for three different people and asked it to figure out who should receive each file. In that original test, it worked. A full YouTube demonstration is coming next week.
How to Use Microsoft 365 Copilot Cowork to Build Word Docs, PowerPoint Decks, and Outlook Emails in One Prompt
Microsoft Copilot Cowork is the most exciting addition to Microsoft 365 Copilot I have used in a while. It is a multi-step agent that works across Outlook, Word, PowerPoint, and your other apps at the same time — give it one prompt and it can search your mailbox, build deliverables in parallel, and even follow up by drafting an email and dropping a meeting on your calendar. In this article, I walk through a real example I ran this morning. I asked Cowork to look through my Outlook inbox and sen
Microsoft Copilot Just Completely Changed: Home, Chat, Cowork, Code, USL & UBB Explained
Microsoft Copilot has a new look with Home and Code tabs, plus Chat and Cowork inside Home. Learn the important difference between USL (User Subscription License) and UBB (Usage-Based Billing), and why seeing Cowork or Code doesn't necessarily mean the usage is included in your subscription.
Email Mail Merge: Personalized Emails Using Excel - Word & Outlook
Need to send personalized emails to individuals all at one time? That is called an " **Email Mail Merge**." I'm going to use Excel, Word, and Outlook - part of Microsoft 365 - to create and send bulk emails out. The order these apps are used would be Excel, then Word, and finally, Outlook. - Excel - stores the data of individuals you want to send a personalized email - Word - where all Mail Merges happen, including an Email mail merge - Outlook - Sends emails to individuals. If you had 100 peo
Outlook mail merge - personalize email messages
You can send an email message out to a contact group (distribution list), or just manually put everyone on the TO or BCC line, but if you want to personalize each recipient’s email message, you need to do a mail merge. Why would you want to do this? If you have 300 customers with Sales Reps, and the Reps are changing which customers they serve, you would email all the customers and include the new Sales Rep contact information. I’m going to demonstrate how to do an email mail merge using Micros