I am having a custom entity named EmailRemainder, having these fields.
Frequency (option set) : Weekly, BiWeekly, Monthly
Contact (lookup)
I have created 3 records with different frequency and contact.
Requirement is: Based on the frequency I need to send a remainder email to the appropriate contacts, (every week or biweek or month) until the EmailRemainder entity records become inactive.
Can you give me some suggestion how we can implement this?