Step by step process of integration between Outlook and Salesforce by Service Account Connection method

This blog post helps you to integrate Microsoft Outlook and Salesforce by using Lightning for Outlook by Service Account connection method.

Integration with Salesforce and sync works only when Outlook email belongs to any one of the below Office 365 editions.

  1. Enterprise
  2. Essentials
  3. Business Premium

Steps to be followed by Global Administrator of Office 365 account belonging to any of above editions :

  1. Visit Microsoft Office 365 site and sign home page
  2. Navigate to Admin Center and go to Active Users section.

    This slideshow requires JavaScript.

  3. Modify the following sections of users who is supposed to have an integrated system with outlook.Roles on users
  4. In the Roles section of user, grant him permissions for Exchange Administrator and Service Administrator under Customized Administrator.check service admin and exchange admin under customised admin
  5. In the Admin Center, hover over the Admin centers icon to find the ‘Exchange’ service.admin centers-exchange
  6. Under permissions, create a new permission.

    This slideshow requires JavaScript.

  7. Provide name to the permission.
  8. Under Roles, add a role called “ApplicationImpersonation”.

    This slideshow requires JavaScript.

  9. In the members section, add all those users who were given “Exchange Administrator” and “Service Administrator” in the previous step.

    This slideshow requires JavaScript.

Head back to Salesforce, after logging in,

  1. Enter Lightning for Outlook and sync in the quick find box
  2. Enable Lightning for Outlook and  Lightning Sync.

    This slideshow requires JavaScript.

  3. Expand the Lightning Sync section after enabling it. You could see two types of connection methods.
    1. OAuth 2.0
    2. Service accountservice account and oauth showing
  4. Choose Service account connection and enter following details.
    1. Provide Username and Password of the global administrator account of Office 365 belonging to the above editions in the “Enter service account credentials” section
    2. On click of save, domain is recognized automatically
    3. In the section to test connection, email address about to be provided should belong to any of the user of the Salesforce org
    4. Provide email address of a user who has been given permissions to his/her user license in the above steps in Office 365
    5. On click of test, connection will be established with the email server

      This slideshow requires JavaScript.

  5. In the Set Sync and check status section, define a Lightning Sync Configuration and make it active
  6. Choose sync direction, manage conflict behavior and field mappings
  7. Choose users whose events and contacts need to be in sync and save configuration
  8. Go back to Lightning for Outlook section and click on check sync button.
  9. Select the user from the lookup to check sync status of events, contacts, connection between outlook and Salesforce

    This slideshow requires JavaScript.

Now users of Salesforce Org(who have been given Service, Exchange permissions by Global Administrator) can go to Office 365 and open Outlook app.

  1. click on the gear icon(Settings) and click on mail.
  2. In the General section, click on manage add-ins
  3. Go to Office store to install an add-in called “Salesforce lightning for outlook”
  4. When a calendar event  is being created in Outlook, Salesforce icon is visible on the top panel
  5. Click on it to authorize with your Salesforce Org.

    This slideshow requires JavaScript.

  6. When a calendar event is being created, when attendees are added, on click of the Salesforce icon, it will search in the Salesforce Org and returns the results with contacts matching the email addresses entered.
  7. On selecting the contact and saving the event, it gets synced to the Salesforce Org creating a calendar event in Salesforce and it relates to the Contact.
  8. If the attendees mentioned are not matching with any contact present in Salesforce Org, a new Contact can be created from the add-in and the event can then be related after sync.
  9. Calendar event that is created without attendees also gets synced to the Salesforce Org and an event is created.
  10. Events created in Salesforce gets synced to Outlook calendar

    This slideshow requires JavaScript.


Therefore Service Account Connection method helps us to sync events between Salesforce and Outlook.

2 thoughts on “Step by step process of integration between Outlook and Salesforce by Service Account Connection method

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s