D365ConsultantDivision of Sataware
Talk to an expert
ERP inside everyday tools

Microsoft 365 integration with Dynamics 365 that your staff will actually use.

Microsoft 365 integration with Dynamics 365 means your people see customer balances in Outlook, share an order in Teams and edit a journal in Excel without leaving the tools they open every morning. Most of these features ship with Business Central and the Dynamics 365 apps already. What they need is correct setup in the admin centers, the right permissions, and a little training so they get used.

Outlook add-in
Business Central contact and document insights in mail
Edit in Excel
change list pages in Excel and publish back
Teams
read Business Central data with a Microsoft 365 licence, once enabled
Woman working on a laptop while sitting on a sofa

What connects to what

Outlook

Mail and calendar

The Business Central add-in shows the sender's customer or vendor card, open documents and balances beside an email, and can create a quote or invoice from it. Dynamics 365 Sales uses its own Outlook app and server-side synchronization to track mail and meetings against records.

  • βœ“Contact insights beside each email
  • βœ“Quotes and invoices from the inbox
  • βœ“Tracked mail against CRM records
Teams

Chat and collaboration

Paste a Business Central link into a chat and it expands into a card colleagues can read. Dynamics 365 Sales records can be linked to Teams channels so the account team shares files and conversation in one place.

  • βœ“Shareable record cards
  • βœ“Contact search from Teams
  • βœ“Channels tied to CRM records
Excel

Spreadsheets that post

Open in Excel exports any list with its filters, and Edit in Excel lets users change lines and publish them back through the Excel add-in, with Business Central validation still applied.

  • βœ“Journal preparation in Excel
  • βœ“Bulk price and item updates
  • βœ“Financial reports exported with formulas
Files

SharePoint and OneDrive

Business Central can save exported files and attachments to OneDrive, and Dataverse apps can store documents in SharePoint folders per record, so contracts and drawings are not buried in personal drives.

  • βœ“Record-level document folders
  • βœ“Shared exports
  • βœ“Microsoft 365 retention policies apply

The setup work nobody mentions in the demo

Each feature has an administrator step that is easy to miss. The Outlook add-in has to be deployed for users or the whole organization through the Microsoft 365 admin center. The Teams app needs to be allowed by Teams policy. Access through Microsoft 365 licences has to be switched on in Business Central, and the permission set that controls what those users can see has to be chosen deliberately, because it applies to every Microsoft 365 user in the tenant.

Dynamics 365 Sales needs a mailbox approval step before server-side synchronization will run, and SharePoint document management needs a site structure agreed in advance. None of this is hard, but skipped steps are the main reason these features sit unused after a go-live.

Sign-in is shared too. Business Central, the Dynamics 365 apps and Microsoft 365 all use Microsoft Entra ID, so multifactor authentication and conditional access policies you set once protect all of them.

Getting it running in your tenant

  1. 1

    Check the tenant

    We confirm which Microsoft 365 plans you hold, how Teams and Outlook add-ins are governed, and whether Business Central or Dataverse already sits in the same tenant as your mailboxes.

  2. 2

    Enable and secure

    Add-ins, Teams apps and document storage are switched on with your administrator, with permission sets chosen to show people what they need and nothing more.

  3. 3

    Show each team its three features

    Sales staff learn the Outlook pane, accounts payable learns Edit in Excel for journals, and managers learn to share records in Teams. Short, role-specific sessions work better than one long demo.

  4. 4

    Look at usage

    A few weeks in, we check which features are used, fix whatever blocked the rest, and retire anything that is not earning its keep.

Everyday tasks this removes from the ERP screen

  • βœ“Looking up a customer's overdue balance before replying to their email
  • βœ“Copying an order number into a chat so a colleague can check it
  • βœ“Retyping a spreadsheet of journal lines into Business Central
  • βœ“Saving a signed contract to a desktop folder nobody else can find
  • βœ“Forwarding a report as an attachment that is out of date by the next morning
Laptop, tablet and phone side by side on a wooden desk
Excel stays in the process, but the numbers post back to the ledger

Microsoft 365 and Dynamics 365 questions

Do our Microsoft 365 users need a Business Central licence to see data in Teams?

Not for reading. Business Central lets users with qualifying Microsoft 365 licences view shared Business Central data in Teams once an administrator enables it and chooses their permission set. Anyone who creates or changes records still needs a Business Central licence. The admin setting and permission choice are part of our setup.

Can we keep using Excel for budgeting and journals?

Yes, and many finance teams should. Edit in Excel sends lines back through Business Central's own validation, so the data still has to be right before it posts. Budgets can also be exported, adjusted and imported the same way.

Does this work if Dynamics 365 is in a different tenant from our email?

Most of these features expect Dynamics 365 and Microsoft 365 to share one Microsoft Entra tenant. If they sit in different tenants, for example after an acquisition, several integrations will not work as designed. We confirm the tenant setup first and recommend the cleanest route if a tenant move is needed.

Where does Copilot fit?

Copilot features appear in Business Central, the Dynamics 365 apps and Microsoft 365, and some are licensed separately. They work best once the basic connections on this page are in place, because Copilot draws on the same data and permissions. Our Copilot page covers what each one does.

Talk to us about your project.

Tell us what you run today and what has to change. A senior consultant replies with a written next step.

Get started

Start with a scoping conversation.

Thirty minutes with a senior consultant - not a sales call. We look at how you run today, tell you plainly whether Business Central is the right fit, and give you an honest sense of scope, cost and timeline before you commit to anything.

What happens next
1
We review your enquiry
A consultant reads it before the call - no discovery questionnaire to fill in.
2
30-minute scoping call
Your processes, your current systems, and the gaps that matter most.
3
Written summary & estimate
Indicative phases, licence counts and a cost range, in writing within three days.
Reply within one business day
NDA signed before discovery on request
No obligation, no cost for the scoping call
Microsoft-certified consultants only
Request your scoping call
Four fields. A consultant replies within one business day.
No cost
Your details stay with our consulting team - never shared, never added to a mailing list.