How to Use Copilot Notebooks for One Client's Emails and Files

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Use Copilot Notebooks for One Client's Emails and Files.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Use Copilot Notebooks for One Client's Emails and Files.

To use Copilot Notebooks for one client, open the Microsoft Copilot app at m365.cloud.microsoft, choose Notebooks (now being renamed Workspaces), select New notebook, name it after the client and add their email threads, files and meeting notes as references. Then ask questions in the notebook's chat: Copilot answers only from those references.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Your licence sets the size of the notebook. Copilot Chat, which comes at no extra cost with eligible Microsoft 365 business plans, allows 50 references per notebook. A paid Microsoft 365 Copilot licence lets you add more, uses the first 300 for answers, and accepts Teams chats, meeting recaps and web links. Clients can't be invited: notebooks don't support sharing outside your organisation.

What do you need before you build a client notebook?

A client notebook needs a work account with free Copilot Chat or a paid Microsoft 365 Copilot licence, and the account must have a SharePoint or OneDrive service plan to create notebooks. Microsoft 365 Personal, Family, Premium and Pro subscribers can use notebooks on a personal account as well, but most firms keep client email on a work account, so the steps below assume one.

The licence matters more here than in most Copilot features, because it decides which kinds of client material can go in at all. Microsoft's Copilot Notebooks licensing page splits it like this (Microsoft's newer help pages call the paid licence the Microsoft Copilot add-on):

In a notebookCopilot Chat (no extra cost)Paid Microsoft 365 Copilot licence
References per notebookUp to 50, all used for answersMore than 300 can be added; the first 300 are used
Email threads, including attachmentsYesYes
Word, Excel, PowerPoint, PDF, text and image filesYesYes
OneNote pages and sections, Loop pagesYesYes
Teams chats, meeting transcripts and AI recaps, meeting invitesNoYes
Web links (URLs) and whole OneNote notebooksNoYes
The source Microsoft lists as "SharePoint and OneDrive"NoYes
Suggested referencesNoYes
Audio overviewsNoUp to 20 a day
Researcher inside the notebookNoUp to 25 a month

Two rows trip people up. Individual Word, Excel and PowerPoint files work on both licences, so a Copilot Chat user can still add the client's quote and drawings one file at a time; what's paid-only is the row Microsoft labels "SharePoint and OneDrive". Teams meeting recaps are paid-only too, so on Copilot Chat the notes from a client meeting need typing into a OneNote page or a Word file before they can go in. If you're unsure which of the two your staff have, what Copilot Chat gives you free compared with Microsoft 365 Copilot sets out the wider differences.

If the left-hand menu shows Workspaces rather than Notebooks, you're in the right place. Microsoft started renaming Copilot Notebooks to Copilot Workspaces in phases from late October 2026. Existing notebooks become workspaces automatically with their content intact, sharing that was already set up carries over, and Microsoft says everything notebooks could do still works. If neither name appears, open the app launcher at the top of the left pane and select Workspaces.

How do you set up one notebook for one client?

Setting up a client notebook takes five steps: open the Copilot app, create the notebook, name it after the client, add references, then write short instructions so answers follow your house style. Allow 20 to 40 minutes for a client with a few months of history; most of that time goes on choosing what goes in.

  1. Open the app. Go to m365.cloud.microsoft and sign in with your work account. In the left-hand menu select Notebooks to expand the list, then All notebooks, then New notebook. After your first notebook, the plus button next to Notebooks starts the next one.
  2. Name it so it sorts. Use client name, job and year in that order, for example "[Client] - bedroom joinery - 2026". Once you have fifteen client notebooks, a consistent pattern means the right one is a glance away.
  3. Add the first references. Under Add content to References, search for files by name, use Upload for files on your computer, pick files with the OneDrive button, or drag them into the box. On a paid licence Copilot also suggests references and lets you filter the suggestions by Files, Meetings, Emails and Sites.
  4. Create it. Select Create. Later additions go through Add references at the top of the Content pane.
  5. Write the instructions. In the Copilot app select More options (the three dots, top right) and then Instructions; in OneNote, select the arrow next to the notebook name and then Copilot instructions. Type them and select Save.

The same notebook also opens in OneNote, at onenote.cloud.microsoft/copilotnotebooks, and you can switch between the two without losing anything. The Copilot app is the lighter view for asking questions; OneNote suits people who already keep their client notes there. If you're weighing which of the two should be the client's home, Copilot Notebooks or OneNote for client notes compares them side by side.

Instructions are where a client notebook earns its keep, because they stop you repeating the same corrections in every prompt. Here is a filled-in set for an illustrative joinery job:

This notebook covers one client: [client name], bedroom and reception joinery, 2026.
The signed quote is "Quote-v3-signed.pdf". Ignore quote versions 1 and 2.
When you give a date, price or quantity, name the reference it came from.
If two references disagree, show both and say which is more recent.
Call the client's project manager "the PM" and the interior designer "the designer".
Write in British English. Keep answers under 200 words unless I ask for more.

A furniture maker's hotel notebook, reference by reference

Here is the build in full for an illustrative case. A six-person furniture maker is making 84 bedroom pieces (42 bedside tables and 42 desks) plus a reception desk for a 42-room hotel refurbishment: a 14-week job worth $86,400. By week six the job lives in 31 email threads with the hotel's PM and the designer, 14 files and 5 sets of meeting notes. The firm runs on Copilot Chat, so the notebook has a ceiling of 50 references, and the office manager plans it on paper before adding anything.

MaterialAvailableAddedReason
Signed quote (PDF)11The baseline for every price and date question
Earlier quote versions20Superseded prices produce wrong answers
Drawings, latest revision (PDF)33Sizes, finishes and fixings
Finishes schedule (Excel)11Shows which finishes are still "TBC"
Variation log (Excel)11Every change request and its price
Delivery plan (Word)11Phases and delivery weeks
Cutting list (Excel)10Workshop data; no client question needs it
Costing sheet with margins (Excel)10Anyone the notebook is shared with could gain access
Site photos of measured openings (JPEG)33Settles "will it fit" questions
Email threads with the PM1917Two were internal forwards of the same thread
Email threads with the designer1212Finish and detail decisions
Meeting notes (OneNote pages)55Typed up after each site meeting
Total50446 slots spare

Six spare slots won't last eight more weeks, because the job has been producing about three new threads a week. So the office manager's Friday routine removes resolved threads (a delivery slot confirmed, a sample approved) to make room. The alternative is one paid seat for the person who runs the notebook: at $21 a month on a yearly subscription, the ceiling moves from 50 references to 300 used, and the Teams recaps from site meetings can go in directly instead of being retyped.

Before the notebook, a question like "what did we agree about the reception desk finish?" meant searching Outlook for the designer's name, opening two drawing revisions and scrolling through meeting notes: about 25 minutes, and the answer still depended on who remembered the phone call. With the notebook it's one question, a two-minute answer and five minutes opening the sources it names. On an illustrative eight such questions a week, that's about two and a half hours back for the owner and the office manager between them, before counting the disputes it heads off.

Which of a client's emails and files belong in the notebook?

A client notebook should hold the material that settles questions: the signed quote, the latest drawings, change requests, the delivery plan and the email threads where dates, prices or specifications were agreed. Everything else can stay in the client's folder, where it's still searchable the normal way.

Five rules keep the answers clean:

  • Latest versions only. If quote v2 and v3 are both in, Copilot can quote either. Keep superseded versions in the folder, not the notebook.
  • Threads, not single messages. Microsoft lists email threads, including attachments, as a reference type on both licences. A thread carries the question and the answer together, which is what you need when a date was agreed over four replies.
  • Nothing you wouldn't show the people you'll share with. Sharing a notebook gives colleagues access to its referenced files wherever Microsoft can grant it, so margin sheets and staff matters stay out.
  • Files from OneDrive or SharePoint, not desktop copies. Microsoft says references stay current as your data changes. A file picked from where the team saves it keeps one version in play; a copy uploaded from someone's desktop is easy to forget about.
  • Notes typed where Copilot Chat can read them. On the free tier, meeting recaps can't be added, so type the five lines that matter into a OneNote page after each meeting.

A quick sum shows why the cap matters on Copilot Chat. Say a client relationship produces 3 threads a week and 1 new file a fortnight, 3.5 references a week. Start with 15 references (quote, drawings, notes) and the notebook reaches 50 around week ten (15 + 3.5 × 10 = 50) unless resolved threads come out. On a paid licence the same notebook could run for well over a year before it reached 300.

Photos deserve a word. JPEG and PNG images are allowed on both licences, which helps with site photos of measured openings or damaged goods. Microsoft also notes that notebooks don't generate images or data visualisations, so don't expect a chart back: ask for a table and build any chart yourself.

What can you ask a client notebook across emails and files?

A client notebook answers questions that need two or more sources at once: what was promised in emails against what was signed, which requests are still unpriced, and what changed since the last meeting. Type each question in the Message Copilot box inside the notebook, and Copilot grounds its answer in the notebook's references.

The first question every client notebook should get compares commitments across sources:

List every delivery date we have agreed with the client. For each one, give the date,
what is being delivered, and the reference it comes from. Then flag any email that
contradicts the signed quote or the delivery plan.

An illustrative answer from the hotel notebook:

Phase 1 (42 bedside tables): week 9, from the signed quote and the delivery plan. The PM asked on 14 April to bring phase 1 forward to week 8; your reply on 15 April agreed "week 8 if the oak finish is confirmed by 20 April". The finishes schedule still shows the oak stain as TBC. Phase 2 (42 desks): week 12, from the delivery plan. Reception desk: week 14, from the signed quote. No email changes phase 2 or the reception desk.

What to fix before anyone acts on it: the answer reads as if week 8 is agreed, but the condition (finish confirmed by 20 April) is the real point, and only the finishes schedule shows it wasn't met. Open the 15 April thread and the schedule, then reply to the PM in plain terms. A notebook is good at putting three sources side by side; deciding which one wins is still your job.

Four more questions that work well on a client notebook:

List every change the client has asked for since the signed quote. For each, give
the date, who asked, our quoted price, and mark any we have not priced yet.
Which questions from the designer are still unanswered? Quote the question,
give the email date, and say who on our side should answer it.
What has changed since the most recent meeting notes? Compare the latest OneNote
page with emails and files dated after it.
Draft a one-page status note for the PM: done, next two weeks, and decisions we
need from them with dates. Use only facts from the references.

The change-request question is the one that pays for the set-up. On the hotel job, an illustrative answer listed seven changes: four priced in the variation log, two priced only in email replies (a $640 change to soft-close runners and a $1,150 upgrade to solid oak tops on the reception desk), and one never priced at all (cable grommets in all 42 desks). The two email-only prices were the risk: neither had reached the variation log, so neither would have reached the invoice. Ten minutes of checking turned a likely argument at final account into two lines added to the log that week.

How do you check a notebook answer before acting on it?

Check a notebook answer by opening the source it names, confirming the date or figure there, and asking what it left out. Microsoft warns that answers may be inaccurate and that Copilot may draw on only some of your references.

A three-step check takes about five minutes and catches most problems:

  1. Open every source behind a number. Prices, dates and quantities get verified in the original file or email, every time. Your instructions already ask Copilot to name the reference; if it doesn't, ask "Which reference does that figure come from?"
  2. Ask what it didn't use. "Which references did you not use for that answer, and could any of them change it?" This catches the newest reply in a thread being missed.
  3. Ask the opposite question. If the answer says there are no unpriced changes, ask "List any email that mentions a change, an extra or an addition" and compare the two lists.

When an old quote crept into the status note

This one is common enough to plan for. In the hotel notebook's first week, before the reference plan above existed, all three quote versions were in. Asked for a draft status note, Copilot gave the desk price as $412 each from v2 instead of $438 from the signed v3, a $1,092 difference across 42 desks. Nobody spotted it until the PM queried the figure, because the note looked right. The fix had two parts: remove v1 and v2 from the references, and add the "ignore quote versions 1 and 2" line to the instructions. Since then, any price in a draft gets checked against the signed PDF before the email goes.

Can you share a client notebook with staff or with the client?

Copilot Notebooks can be shared with colleagues inside your organisation but not with anyone outside it, so the client can't be invited. Everyone you invite gets edit access, and Microsoft grants them access to the notebook's referenced files wherever your own permissions allow it.

  1. Open the notebook and select Share in the upper right corner.
  2. Enter colleagues' names or email addresses.
  3. Select Invite. An "Invite successful" message lists who was added, and the people icon next to Share shows how many people have access.

Before you press Invite, know what sharing does on Microsoft's own terms, from Microsoft Learn's overview of notebook and page permissions and the support pages:

  • Each person's chats in a shared notebook stay private. You share the references, not the conversations.
  • Read-only members aren't supported yet. Everyone invited can edit.
  • Groups can't be added, because notebooks live in the creator's personal storage container, so invite people one by one.
  • If you don't have sharing rights on a referenced file, the colleague has to request access to it separately. A OneNote section in the notebook needs the whole OneNote notebook shared.
  • Paid-only sources such as Teams chats and SharePoint or OneDrive content are only usable by colleagues who also have a paid licence.

The sharing rule that catches small firms is the files. In an illustrative case, a car repair garage shared its fleet-customer notebook with a new service adviser in week one. The notebook referenced the fleet pricing sheet, which showed the customer's discount and the garage's parts margin, and the adviser could now open it. Nothing went wrong, but the owner hadn't meant to show margins to someone two weeks into the job. The tidy-up: take the pricing sheet out of the references, check who has access to the file in OneDrive and remove anyone who shouldn't, and keep a rule that a notebook only references files the whole account team can already see. If your permissions are loose to begin with, tidying SharePoint permissions before Copilot goes live covers the wider job.

For the client, send something they can open: a Word document or PDF built from the notebook's answers. Copilot Pages don't solve it either, because guests can't open a shared Page through its link. Pages are still the better place for your team to draft the document together first, as co-editing proposals in Copilot Pages shows.

Is a notebook better than a client folder in OneDrive and Outlook?

A notebook beats a plain client folder when you need answers that join emails to documents; a folder still wins for keeping everything, sharing with the client and holding the record after the job ends. Most firms need both: the folder as the record, the notebook as the place to ask questions.

JobClient folder (OneDrive plus an Outlook folder)Client notebook
What it holdsEverything, limited only by storage50 references on Copilot Chat; 300 used on a paid licence
Finding one factSearch each place, open and readAsk one question; Copilot names the source
Questions across emails and filesYou join them up yourselfCopilot joins them up; you check
Sharing with the clientYes, with normal sharing linksNo, internal only
Sharing with staffFolder permissionsInvite by name; everyone edits; referenced files shared
Weekly upkeepSave files in the right placeAdd new threads, remove resolved ones
After the jobStays as the recordKeep or delete; deletion is permanent
Extra costNoneNone on Copilot Chat; a paid seat for more

A paid licence already lets Copilot Chat draw on your work data across Microsoft 365, so why build a notebook at all? Because a broad search pulls in every client. Ask "what did we agree about delivery?" across all your work data and the answer may blend two hotel jobs. Inside a notebook, Microsoft says Copilot doesn't look at your wider OneDrive, email, Teams chats or the web, only the references you added, so the answer stays with one client's history.

The before and after for the furniture maker's Monday client check shows the difference. Before: open the client's Outlook folder, sort by date, skim 11 new emails, open the variation log to see if anything new was priced, open the delivery plan to check dates, and write three lines for the team, about 35 minutes. After: ask the notebook "What arrived since last Monday, what does it change, and what do we owe the client this week?", open the two sources it flags, and paste the answer into the team chat, about 10 minutes. The folder hasn't gone anywhere; it's simply no longer the place where the thinking happens.

If you're choosing between Microsoft's notebooks and Google's equivalent, Gemini Notebook against Copilot Notebooks for small firms compares the two.

If you want help fitting client notebooks into how your firm runs its client work, I offer one-to-one AI consultations for small businesses.

What does a client notebook cost a small team?

A client notebook costs nothing extra on Copilot Chat, which comes with eligible Microsoft 365 business plans. A Microsoft 365 Copilot Business licence costs $21 a user a month on a yearly subscription, or $25.20 a user a month on a monthly subscription, according to Microsoft's pricing page.

Until 31 December 2026, Microsoft's page also shows a first-year promotion of $18 a user a month on a yearly subscription; an annual commitment is required and the discount covers the first year only. There's a one-month free trial, which needs a credit card and turns into a paid subscription unless you cancel. Microsoft also notes usage-based billing for some advanced AI features, charged on top of the licence.

Paid seatsCopilot Chat onlyYearly at $21First year at $18 (promotion)Monthly at $25.20, for 12 months
1$0$252$216$302.40
3$0$756$648$907.20
6$0$1,512$1,296$1,814.40

Few small firms need every seat paid for notebooks alone. A sensible split is one paid seat for the person who builds and maintains client notebooks, with everyone else on Copilot Chat. The catch is that colleagues on Copilot Chat can't use the paid-only sources in a shared notebook, so the Teams meeting recaps only help the paid user. If the whole team needs a decision from a meeting, type it into a OneNote page, which every licence can read.

Which other client relationships suit a one-client notebook?

Client relationships suit a notebook when the history spans emails and documents and the same questions come up every week. Contract accounts, fleet customers and wholesale stockists are three common fits, and each needs a slightly different set of references and questions.

A pest-control firm with a 14-building contract

A pest-control firm holding a quarterly contract for a property manager's 14 buildings fields the same questions every month: when was building 6 last treated, what was used, and what were the tenants told? The notebook holds the contract, this year's visit reports as PDFs (one per building per quarter, 42 so far) and the threads with the property manager. With the threads included that's well over Copilot Chat's 50, so this is a case for a paid seat, or for one notebook per group of seven buildings. The question that earns its place: "Summarise every visit to building 6 this year, the treatments used, and anything we promised the property manager by email, with dates."

A car repair garage with a 12-van fleet account

For a garage servicing a courier firm's 12 vans, the notebook holds the fleet agreement, each van's job cards as PDFs and the email threads about invoice queries. Twelve vans with three job cards each this year is 36 files; add the agreement and eight threads and it fits under 50 with five to spare. The useful question: "For each van, list this year's jobs, the parts replaced, and any work we recommended that the customer declined, with the job card it comes from." The declined-work list tends to become next month's bookings.

An online clothing store with a wholesale stockist

An online clothing store selling wholesale to a boutique keeps the line sheets, two seasons of order confirmations and the stockist's emails in one notebook. The cross-source question is "Which styles did they reorder this season, which did they drop, and what reasons did they give in emails?" Copilot can return the list as a table, but notebooks don't draw charts, so the season-on-season comparison by units and value is a spreadsheet job.

If turning the stockist's orders into a season-by-season spreadsheet is the slow part, try The Complete Excel Course with AI Integration on Coding Liquids.

Keeping the notebook useful until the job closes

A client notebook goes stale quickly if nobody tends it. A 15-minute Friday routine keeps it current:

  1. Add the week's new threads and files through Add references at the top of the Content pane.
  2. Remove resolved threads if you're close to the 50-reference limit on Copilot Chat.
  3. Update the instructions when something changes, such as a newly signed variation or a new contact at the client.
  4. Ask "What changed this week, and what do we owe the client by next Friday?" and paste the answer into Monday's team notes.

When the job closes, decide what to keep. Deleting a notebook is permanent for now (Microsoft says recovery is in development), so copy the answers worth keeping, such as the final list of changes and agreed prices, into a Word document in the client's folder before you delete. Keep the notebook instead if the client is likely to come back: next year's job then starts with this year's decisions one question away.

One last setting worth knowing: everything in a shared notebook is editable by everyone invited, including the references. If a colleague removes the signed quote by mistake, answers quietly lose their baseline. Make the Friday routine include a ten-second glance at the reference list to confirm the signed quote and the latest drawings are still there.

Copilot Notebooks for client work: quick answers

How many references can one Copilot notebook hold?

Copilot Chat users can add up to 50 references per notebook, and Copilot uses all 50 when it answers. With a paid Microsoft 365 Copilot licence you can add more than 300, but only the first 300 are used. Shared locations are sampled rather than read in full, so add the client's key files directly instead of relying on a whole folder.

Can my client open or edit a Copilot notebook?

No. Copilot Notebooks don't support sharing outside your organisation, so a client or an outside designer can't be invited. Copilot Pages won't work as a route either, because guests can't open a shared Page through its link. Send the client a Word document or PDF built from the notebook's answers and keep the notebook as your team's internal working file.

Do Copilot Notebooks need a paid Copilot licence?

No. Eligible Copilot Chat users can create notebooks at no extra cost, as long as the work account has a SharePoint or OneDrive service plan. The paid Microsoft 365 Copilot licence raises the limit to 300 references used, and adds Teams chats, meeting transcripts and recaps, web links, suggested references and audio overviews.

Why does my Copilot app show Workspaces instead of Notebooks?

Microsoft is renaming Copilot Notebooks to Copilot Workspaces in phases that began in late October 2026. Existing notebooks become workspaces automatically with their content and any existing sharing intact, and Microsoft says everything notebooks did still works. If you see neither name, open the app launcher at the top of the left pane and select Workspaces.

Does Copilot read my whole mailbox when I ask inside a notebook?

No. Inside a notebook Copilot answers only from the references you added, and Microsoft says it doesn't search the rest of your OneDrive, email, Teams chats or the web. That is the main reason to give each client their own notebook: answers can't drift into another client's emails or quotes.

Can I recover a Copilot notebook after deleting it?

Not at present. Microsoft's help says deleting a notebook is permanent and that notebook recovery is still in development. Before you delete a finished client's notebook, copy any answers worth keeping, such as the final list of changes and agreed prices, into a Word document saved in the client's folder.

Further reads

Sources: Microsoft Support pages on getting started with Copilot Notebooks, Copilot Notebooks licensing options, adding references, custom instructions, getting answers, sharing a notebook, how notebooks work, the move to Copilot Workspaces and the Notebooks FAQ; Microsoft Learn's overview of Copilot Pages and Copilot Notebooks permissions; Microsoft's Copilot business pricing page. All read 22 November 2026.

Ready to put AI on the jobs that eat your week?

No data team or big budget needed. In a 1:1 consultation I show small and medium-sized businesses and self-employed people which AI tools they can use, one workflow at a time.

Book a 1:1 call with me