---
id: topic/business-central/get-started/get-productive-in-business-central/get-the-most-out-of-microsoft-365-apps
type: topic
title: Get the most out of Microsoft 365 apps
summary: "Microsoft 365 integration in Business Central: opening files in OneDrive, saving contacts to Outlook, sharing records in Teams, merging data into Word templates, and viewing or editing data in Excel. It answers how-to questions about using these apps with Business Central data."
tier: official
language: en
review:
  state: reviewed
  by: opus
  at: "2026-10-07T02:24:38.557Z"
  flags: []
generated:
  at: "2026-10-08T00:04:31.553Z"
  pipeline: 0.2.0
  prompts:
    hub-topic: 1
  input_hash: 7f90c881c6ea0f0dc373936258dcf52f0aced838089078d40b138fdd9c9faecd
evidence:
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-share-onedrive
    title: Opening Business Central Files in OneDrive
    date: "2025-10-21"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/save-business-contacts-to-outlook
    title: Save Business Contacts to Microsoft Outlook
    date: "2026-03-13"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-working-with-teams
    title: Sharing Business Central records in Microsoft Teams
    date: "2025-10-23"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/ui-mail-merge
    title: Using Word templates for bulk communications
    date: "2024-11-13"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-work-with-excel
    title: Viewing and editing in Excel from Business Central
    date: "2026-01-26"
    commit: null
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/across-share-onedrive
    - https://learn.microsoft.com/dynamics365/business-central/save-business-contacts-to-outlook
    - https://learn.microsoft.com/dynamics365/business-central/across-working-with-teams
    - https://learn.microsoft.com/dynamics365/business-central/ui-mail-merge
    - https://learn.microsoft.com/dynamics365/business-central/across-work-with-excel
  objects:
    - object/page/1480
  features: []
  topics:
    - topic/business-central/get-started/get-productive-in-business-central
  localizations: []
  videos: []
  posts: []
  guidelines: []
learn_toc_path:
  - Get started
  - Get productive in Business Central
  - Get the most out of Microsoft 365 apps
toc_file: business-central/TOC.md
parent: topic/business-central/get-started/get-productive-in-business-central
children: []
coverage:
  learn: 5
  code: 1
  video: 0
  blog: 0
  guideline: 0
bc_forms:
  - 1480
member_hash: 3d41d31b8cd5c8fabb32ff8b13e613d643009607e380f76cf09f744501361029
narrative: generated
---

# Get the most out of Microsoft 365 apps

> Microsoft 365 integration in Business Central: opening files in OneDrive, saving contacts to Outlook, sharing records in Teams, merging data into Word templates, and viewing or editing data in Excel. It answers how-to questions about using these apps with Business Central data.

Path: [Get started](../../get-started.md) > [Get productive in Business Central](../get-productive-in-business-central.md) > Get the most out of Microsoft 365 apps · tier official · system none · narrative reviewed (checked by Opus)

## Overview

This section covers five ways to work with Business Central data in Microsoft 365 apps. Each page covers one app: OneDrive for opening and sharing files, Outlook for contacts, Teams for sharing records, Word for bulk communications, and Excel for analysis and editing.

The pages are independent, so start with the app that matches your task. For bulk letters or emails to customers, vendors, or contacts, go to the Word templates page. For working with list data in a spreadsheet, go to the Excel page. For collaboration, use the Teams and Outlook pages. The OneDrive page covers file sharing and permissions.

## Key points

- OneDrive: open Business Central files in online applications, share with specific people using Share, Send link or Copy link, and control permissions through link settings.
- Outlook: save Business Central contacts to Outlook and Teams, with optional two-way synchronization and contact filtering (2026 release wave 1).
- Teams: share records as interactive cards using the Business Central app for Teams, or share direct page links with Share Link and Share to Teams.
- Word templates: merge data from Business Central entities, related or unrelated, into templates for personalized bulk documents to customers, vendors, and contacts.
- Word templates support field selection, template upload, and email integration.
- Excel: Open in Excel exports list data for analysis, while Edit in Excel lets you change data and publish it back to Business Central.
- Excel features include filter support, the Excel add-in, multi-environment support, and agent mode.

## Learn pages

- [Opening Business Central Files in OneDrive](https://learn.microsoft.com/dynamics365/business-central/across-share-onedrive): Learn how you can share Business Central data through OneDrive for Business.
- [Save Business Contacts to Microsoft Outlook](https://learn.microsoft.com/dynamics365/business-central/save-business-contacts-to-outlook): Learn how to synchronize Business Central contacts with Microsoft Outlook and Teams to streamline communication and access contact details effortlessly.
- [Sharing Business Central records in Microsoft Teams](https://learn.microsoft.com/dynamics365/business-central/across-working-with-teams): Learn how to use the Business Central app for Microsoft Teams.
- [Using Word templates for bulk communications](https://learn.microsoft.com/dynamics365/business-central/ui-mail-merge): Word templates can make it easy to bulk create documents that are personalized for specific entities.
- [Viewing and editing in Excel from Business Central](https://learn.microsoft.com/dynamics365/business-central/across-work-with-excel): Learn how to open pages in Microsoft Excel from Business Central for better data analysis.

## Business Central pages and reports

The pages, reports and queries this hub's Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

- [Page 1480 "Excel Centralized Depl. Wizard"](../../../../objects/page/1480.md) · captioned "Excel Add-in Centralized Deployment" · on [Table 1480 "Edit in Excel Settings"](../../../../objects/table/1480.md)

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn's own.