Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Email Templates Used Count

Posted on by 1,672

Hi,

I need to get the count of email sent using an email template.

There is an out of the box field  "UsedCount" in the Email Template entity, but this field is empty for all the email templates.

Is there any standard method to get the count of emails send using an email template from this field? 

Thanks in advance.

*This post is locked for comments

  • Verified answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at
    RE: Email Templates Used Count

    Yeah true.. Try this approach for coding . Create a rollup field on email template entity & on create of the email entity check some particular phrase of the template if there update a custom field to identify is it template 1 or 2 etc.  Then sum up the email activity using the rollup in email template entity.

    Hope this helps

  • Verified answer
    Nijos Profile Picture
    Nijos 1,672 on at
    RE: Email Templates Used Count

    Hi Syed and Mansoor,

    Even I thinks the same, but since there is an out of the box field I just wanted to confirm that, there is no other standard methods other that custom coding.

    Thanks

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Email Templates Used Count

    Hi Nijo,

    I don't think Microsoft automatically updating UsedCount field. Better you can try out some custom coding method to update this field based on the sent email count. Probably use plugin.

    Thanks,

    Mansoor

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at
    RE: Email Templates Used Count

    I dnt think it updates the count upon using number of times in email.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans