web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Automate Birthday eDM

(0) ShareShare
ReportReport
Posted on by

Hi all,

I am a relative newbie to Microsoft Dynamics CRM.

we are using Dynamics 365 solution with connection to Click Dimensions for our Marketing implementation and our offer is a B2C program.

We have our system set so that we have a calculation that allows a 'next birthday' field available to automate birthday email sends.

My query is - what is the process to automate a template to be personalised and send to someone on either the day of or day before their birthday, and also ensure that the person receiving the send cannot receive it more than once in 11 months (ensuring changes of birthdate do not allow for multiple sends). All of our data is retrieved from Source Data based on an App and transactions and changes made in said App, source data overrides CRM data were fields are linked.

Any assistance would be great!

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    AndrewLy365lyf Profile Picture
    6 Most Valuable Professional on at

    Hi AllyC,

    I would create an attribute on the contact record called Yearly Birthday Email Sent (Boolean).  Then using the initial workflow that you used to perform the email send change the initial criteria to "when Yearly Birthday Email Sent = False), perform the send, then Set this flag to True.

    Finally, have a separate workflow triggered on update of Contact : Yearly Birth Email Sent, and set the criteria to "if the Yearly Birthday Email Sent = True" wait for 11 months and then set this to False.

    The above would work purely out of the box.  You could also write a plugin that performs the second workflow across all contacts, that would avoid you triggering jobs for all your contacts.

    Hope that helps.

    Regards,

    Andrew

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans