Sent Email to Manager Case Information Details

(0) Share

Report

Posted on by Community Member

Hi Everyone,

I have a requirement. I need to send case information detail (open cases, resolved cases, agent cases) from customer service every day. How to achieve this one. please share your ideas

Thank you

Vetri vel G

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

PerezAguiar Microsoft Employee on at

Like (0)

Report

Hey Vetrivel.

I can think at least on the following ways to achieve your request:

Option 1: Use Data Export Service to put the data into an AzureSQL or SQL Server on Azure. From there, create the report on your side and send the email using your code (PowerShell, SQL, etc)

Option 2: You can create a Dashboard with the desired data, and then use Microsoft PowerAutomate to send a recurring email (every week, every month) with the link to the dashboard. You can read more on community.dynamics.com/.../add-report-to-dashboards-in-crm-2015-2016 and flow.microsoft.com/.../ can help on this.

Option 3: Use third party. zapobjects.com/.../ , skyvia.com/.../dynamics-crm or Click2Export.

Option 4: You can use PowerAutomate to generate the PDF and send it by mail. You have a nice explanation on

2die4it.com/.../

Hope it helps!

Was this reply helpful? Yes No