#SET UP EMAIL FOR EXCEL ON MAC HOW TO#

On the APIs my organization uses, select the Business Central application.From the application's Overview, select API Permissions.This permission allows users of the Excel add-in to access the OData web services to read and write data. Give the Azure AD application for the Excel add-in delegated permission to access the Business Central application Web API in Azure AD (which you exposed earlier in this article). Grant the Excel add-in application permission to access the Business Central application Web API. Make a note of the name or copy the Application (Client) ID for the next step. When completed, the Overview displays in the portal for the new Excel Add-in application. Select the type to Web, and in the redirect URL box, enter URL for signing in to the Business Central Web client, for example The URI has the format such as or Important The portion of the reply URL after the domain name (in this case BC190/SignIn) is case-sensitive, so make sure that the web server instance name matches the case of the web server instance name as it is defined on IIS for your Business Central Web Server installation. Specifies the type of application that you're registering and the redirect URI (or reply URL) for your application. For purposes of this article, select Accounts in this organizational directory only. Specifies which accounts that you would like your application to support. The name of your application as it will display to your users, such as Excel Add-in for Business Central. When you add an application to an Azure AD tenant, you must specify the following information: Setting In the Azure portal, register an application in the Azure AD for the Excel add-in.įor guidelines, see Register your application with your Azure Active Directory tenant. The Excel add-in requires that you add (register) a separate Azure AD application in the Azure AD tenant. When Azure AD authentication was set up for your Business Central deployment, an Azure AD tenant was created in Microsoft Azure, and an application for Business Central was registered in the tenant. Register and configure an application in Microsoft Azure

#SET UP EMAIL FOR EXCEL ON MAC HOW TO#

Before the Excel add-in can be configured, you must configure the Business Central application in Azure AD to expose its Web API.įor information about how to expose the Web API, see Quickstart: Configure an application to expose web APIs. When Business Central is configured for Azure AD authentication, the Business Central application is registered as an application in an Azure AD. If your deployment is multitenant, Business Central Web client must accept host names for tenants.įor more information, see Configure the Web Server to Accept Host Names for Tenants.īusiness Central client computers have a supported version of Excel.įor more information, see System Requirements.Įxpose the Business Central application Web API in Azure AD OData enabled and uses Secure Sockets Layer (SSL) for authentication.įor more information, see Using Security Certificates with Business Central On-Premises.īusiness Central Web Server configured to use SSL (https).įor more information, see Configure SSL to Secure the Connection to Web Client.

For more information, see Authenticating Users with Azure Active Directory. The Business Central Server instance, clients, and users must be configured for Azure Active Directory (Azure AD) authentication, including OData. Your on-premises deployment must meet the following prerequisites:Īzure Active Directory (Azure AD) used to authenticate users.

The Excel add-in is not available in the mobile apps.

The add-in is based on the Microsoft Dynamics Office Add-In available from the Office Store.įor more information about how users work wth Excel from Business Central, see Viewing and Editing in Excel From Business Central. When this add-in is set up, the Edit in Excel action is added. But the Open in Excel action doesn't allow them to push changed data back to Business Central. Without this add-in, users can open a list page in Excel from the Open in Excel action on the page. Users can get fresh data from Business Central into Excel and push updated data from Excel to Business Central. You can set up the Business Central deployment to support an add-in that enables users in the Business Central client to work with data from list pages in Excel. This article does not apply to the older Excel add-in that was available for installation with the Dynamics NAV Client connected to Business Central client by using the Business Central Setup in versions older than 2019 release wave 2.

Set up email for excel on mac