Steps to enable import of contacts and email messages

1. Create and configure an application in Microsoft Entra ID to obtain an OAuth 2.0 client ID and secret value. See Getting OAuth 2.0 client ID and secret for Entra ID.

2. Go to | Administration | Email and Documents | OAuth 2.0 Settings for Importing Contacts and Emails, select Change, and enter the client ID and secret value you obtained in step 1. See OAuth 2.0 settings for importing contacts and email messages.

   This enables the import of contacts and emails and allows the users to authenticate against Entra ID and connect to their organizational Exchange Online accounts.

3. Enable email import for a custom entity by activating read-only SData external access:

   1. Go to | Administration | Customization | <custom entity name>.

   2. Open the External Access tab, select Change and set Read-only SData to Yes.

   3. Select Save.

4. Enable write access to the comm_caseid field of Communication. This is required so that users and info managers could view the Case into which an email is imported.

   1. Go to | Administration | Customization | Communication.

   2. In the Field Name column, locate comm_caseid.

   3. In the row where comm_caseid is located, select the edit button () in the Field Security column.

   4. In the Write Access column, select Allow, and select Continue.

5. Set the maximum file size for each attachment that can be imported together with emails. Attachments exceeding this maximum file size are not imported.

   1. Go to | Administration | Email and Documents | Documents & Reports Configuration.

   2. Set the maximum file size in the File size limitation (MB) option. For details, see Document and report settings.

6. Complete these optional tasks if necessary:

   • Enabling pre-2023 R1 custom entity for email import.

   • Changing number of folders shown for Exchange Online account

7. Instruct the Sage CRM users to connect to their organizational Exchange Online account as follows. Note that users cannot connect to personal Microsoft accounts.

   1. Go to | Preferences.

   2. Do one of the following:

      • If you are connecting to your email account for the first time, select Connect to Email Account. This button is available only if your system administrator has enabled the import of contacts and email messages.
      • If you are already connected to an email account and would like to switch to a different account, select Switch Email Account.

   3. When prompted, enter the user name and password for the organizational Exchange Online account from which to import data.

When their organizational Exchange Online account is connected, the users can import data into Sage CRM:

• To import and file email messages, open a record and select Import Emails.

• To import contacts, go to the Contacts tab, and select Import Contacts.