Skip to content

Workflow guide

How to Connect Microsoft 365 to Claude—and Reconcile a Project Date Across Files, Email and Teams

Use the right work account, confirm your admin finished setup, check one file and one email, then ask Claude which project date was proposed, which was agreed and what is still missing.

By Christian Stewart, Founder and EditorPublished 28 Oct 2026Documentation reviewed 28 Oct 2026

Project dates drift in Microsoft 365. The plan in SharePoint says 14 March, a vendor email two weeks later floats the 21st, and a Teams thread ends with someone writing “ok, 21st works.” Whether the date actually changed depends on who said it and whether anyone with authority agreed.

Connected Claude can search those places for you. The useful habit is to make it show each source side by side—file, email, Teams message—and to keep “proposed” apart from “agreed.”

This walkthrough uses Anthropic’s Microsoft 365 connector for Claude. Product claims were checked against official Anthropic documentation on October 28, 2026. AI assisted the research and writing. The prompts and the fictional example are Connector Scout editorial recommendations, not results from hands-on testing.

Quick answer

The Microsoft 365 connector is available on all Claude plans, but needs a work Microsoft 365 account in a Microsoft Entra tenant; personal Outlook.com or Hotmail accounts cannot be used. An Entra Global Administrator must grant one-time consent for the tenant, and on Team and Enterprise a Claude organization Owner enables it. Then open Customize > Connectors, find Microsoft 365 and select Connect. Claude reads only what you can already see, when you ask. Write tools exist only if your admin enabled them. (Anthropic’s Microsoft 365 guide)

Account
Work Microsoft 365 account in an Entra tenant
Admin steps
Entra Global Admin consent; Claude Owner enablement on Team/Enterprise
Covers
SharePoint, OneDrive, Outlook email and calendar, Teams you take part in

The walkthrough ends with your review and anything you choose to send yourself. Prompts are not substitutes for checking your account, permissions and the sources themselves.

Before you connect: the right account and your admin

The connector is available on Free, Pro, Max, Team and Enterprise plans. It needs a work Microsoft 365 account tied to a Microsoft Entra tenant; personal accounts such as @outlook.com, @hotmail.com or @live.com cannot be used. If you are not sure which kind you have, ask IT. (Anthropic’s Microsoft 365 guide)

Who has to do what before Microsoft 365 works in Claude

Grant one-time tenant consent

Who
A Microsoft Entra Global Administrator
When
Every tenant, before anyone connects

Enable Microsoft 365 for the organization

Who
A Claude organization Owner
When
Team and Enterprise plans

Re-consent and enable write tools

Who
Entra admin and Claude organization
When
Only if your organization wants write tools

Connect your own account

Who
You
When
After the steps above

If you try before consent is granted, you will see an error saying an administrator must grant app permissions. Admins can follow Anthropic’s admin setup guide rather than steps reproduced here. (Anthropic’s Microsoft 365 guide; Anthropic’s admin setup guide)

Connect Microsoft 365 to Claude

  1. Open Customize > Connectors in Claude.
  2. Find Microsoft 365 and select Connect.
  3. Sign in with your work Microsoft 365 account when prompted.
  4. In a chat, use the + button > Connectors to turn Microsoft 365 on or off for that conversation.

Once connected, it also works in Claude for iOS and Android. Under Tool permissions you can switch off individual tools, for example keeping document search while turning off email. (Anthropic’s Microsoft 365 guide)

What Claude can reach—and what it cannot

Claude uses delegated permissions: it can reach only data you can already see in Microsoft 365, and only when you ask a question that needs it. It does not run background searches just because you connected. (Anthropic’s Microsoft 365 guide; Anthropic’s admin setup guide)

Microsoft 365 coverage details worth knowing before you rely on a search

SharePoint and OneDrive

What the documentation says
Sites and libraries you can access; no Sites.Selected allowlist to limit the connector to chosen sites

File types

What the documentation says
Word, Excel, PowerPoint (including older formats), PDF and plain-text files; other files appear in search but cannot be opened

OneNote

What the documentation says
Notebooks appear in search but cannot be read; export pages to Word or PDF

Outlook mail

What the documentation says
Every folder in your primary mailbox, including Archive; not the separate Online Archive mailbox

Shared mailboxes

What the documentation says
Ones you already have delegate access to, including folder-level delegation

Teams

What the documentation says
Chats and channels you take part in; private channels only if you are a member

Naming a site in your prompt narrows the requested search; it does not revoke access to other authorized SharePoint content. Microsoft 365 permissions, administrator consent and tool controls determine actual access. (Anthropic’s Microsoft 365 guide)

Check one file and one email you already know

Prompt 1: Check one known file and one known email
Use Microsoft 365. First, find the file named [file name] in the [site or library name] SharePoint site (or my OneDrive). Tell me its exact name and location and quote one short sentence from it word for word. Second, find the email from [sender] about [subject] from around [date]. Give me the subject line, the date and one short quoted sentence. If you find something similar but not these exact items, say so instead of guessing. Do not send, create or change anything.

Open both yourself and compare. If a known file is missing, check you can open it in Microsoft 365, that it is in SharePoint or OneDrive rather than only on your computer, and try the exact file name or the site name. Recently uploaded files may take time to become searchable. (Anthropic’s Microsoft 365 guide)

Reconcile a date across the plan, email and Teams

Ask for each source separately, then ask which one is the latest agreed position. The structure is our recommendation, not a Microsoft or Anthropic feature.

Prompt 2: Gather date mentions from each source
Use Microsoft 365. For the [project name] project, find mentions of the [milestone, e.g. go-live] date in: 1. The project plan file [file name] in [site]. 2. Outlook emails about [project] since [date]. 3. Teams chats or channels about [project] since [date]. For each mention give the source type, the file or subject or channel, the author, the date written and the exact quoted words. Do not merge them yet. Then list places you did not search or items you could not open.
Prompt 3: Decide what is proposed, agreed or missing
Using only the mentions you quoted above, build a table with columns: Date mentioned | Proposed or agreed | Who said it and their role if stated | Evidence | Missing evidence. Mark a date as agreed only if a message explicitly confirms it. Note if the plan file was not updated after a later agreement. Say who appears to own the milestone and whether that is stated or inferred. Do not fill gaps from general knowledge.

A fictional example

This is an illustration, not a real result. Names, files and dates are invented.

Fictional reconciliation: source facts, interpretation and missing evidence

Plan.xlsx in the Ops site, edited 2 Mar: “Go-live 14 March, owner: Jordan”

Reasonable interpretation
The plan records 14 March as the go-live date
Missing evidence
Who approved that date and whether it changed later

Email from the vendor, 10 Mar: “Could we move go-live to the 21st?”

Reasonable interpretation
A new date was proposed by the vendor
Missing evidence
Any internal reply accepting it

Teams #ops-launch, 12 Mar, Priya: “ok, 21st works for us”

Reasonable interpretation
The team may have accepted the 21st
Missing evidence
Whether Priya can approve it; Jordan has not confirmed

The honest output here is “21 March proposed, informally accepted, not confirmed by the plan owner”—not “go-live is the 21st.”

Draft the follow-up in Claude

Prompt 4: Draft a follow-up in this chat
Based on the table above, draft a short follow-up email to [plan owner] under 150 words. State what the plan says, what was proposed and where, and ask them to confirm the date and update the plan. Quote the sources briefly. Show the draft here in this chat only—do not create a draft in Outlook, send anything, or change any calendar event or file.

That last instruction is task direction, not a technical lock. Whether Claude can write at all depends on your admin: if write tools are enabled, Claude can draft and send email, manage calendar events, create and update files and send Teams messages, always within your existing permissions. Without them, the integration is read-only. (Anthropic’s Microsoft 365 guide)

A draft shown in the chat is different from a draft saved in your mailbox. If write tools are on, know the details: email writes cannot include attachments; emails Claude sends carry an agent-initiated header; creating or updating a calendar event makes Microsoft 365 notify attendees; and sending a Teams chat message or channel post always asks you to confirm first. Write tools also have per-user limits. (Anthropic’s Microsoft 365 guide; Anthropic’s admin setup guide)

Troubleshooting

Common Microsoft 365 connector problems in Claude

Sign-in or authentication fails

Next check
Work account in an Entra tenant, active license, tenant consent granted, third-party app policies; try another browser without blocking extensions

Error that an administrator must grant permissions

Next check
Entra Global Admin consent; on Team/Enterprise, Owner enablement

A file you know is not found

Next check
Can you open it in Microsoft 365? Is it in SharePoint or OneDrive? Try the exact name or site

“mime type … is not allowed”

Next check
The file type, such as OneNote, is not readable; export to Word or PDF

An old email is missing

Next check
It may be in the Online Archive, which is not searched

Write tools are not shown

Next check
Your admin must re-consent to updated permissions and enable write tools

Disconnecting and data handling

Disconnect from Customize > Connectors. That removes Claude’s access, and reconnecting does not need admin re-approval while consent is still active. Admins or users can also revoke access in Microsoft Entra ID. (Anthropic’s Microsoft 365 guide; Anthropic’s connector security guide)

Anthropic describes the connector as an Anthropic-hosted proxy that retrieves data on demand and does not cache file content. Tool results that become part of a saved chat are retained with that chat, so treat a chat containing work email like the email itself. (Anthropic’s connector security guide)

For the ChatGPT side of Microsoft 365, see our Outlook setup guide and SharePoint setup guide. For the record behind this connection, see Claude + SharePoint via Microsoft 365, and the connector permissions guide for evaluating access.

Connector Scout is independent. It is not affiliated with, endorsed by or sponsored by Anthropic or Microsoft, and this guide contains no sponsored or affiliate links.

Sources

  1. [1] Anthropic, Connect to Microsoft 365
  2. [2] Anthropic, Set up the Microsoft 365 connector
  3. [3] Anthropic, Microsoft 365 connector security guide

Accessed and reviewed 28 Oct 2026.