Hi,

You need to create a model and based on that model you can create a schedular action

Create a Scheduled Action, Define a Function to Send Emails, Create an Email Template, Configure Email Sending, Link Scheduled Action with Function:


from odoo import api, fields, models

class Reminder(models.Model):
    _name = 'your.module.reminder'
    _description = 'Activity Reminder'

    name = fields.Char(string='Activity Name', required=True)
    due_date = fields.Date(string='Due Date', required=True)
    user_id = fields.Many2one('res.users', string='User', required=True)

    @api.model
    def send_reminder_emails(self):
        # Triggered by scheduled action
        upcoming_activities = self.search([('due_date', '=', fields.Date.today() + timedelta(days=7))])

        for activity in upcoming_activities:
            template = self.env.ref('your.module_email_template')
            template.send_mail(activity.id, force_send=True)

class ReminderEmailTemplate(models.Model):
    _name = 'your.module.email.template'
    _description = 'Reminder Email Template'

    name = fields.Char(string='Template Name', required=True)
    subject = fields.Char(string='Email Subject', required=True)
    body_html = fields.Html(string='Email Body', required=True)

Hope it helps

Hi 

You can Create Automated actions for Mail activity based on the due days.

Automated Actions

Automated actions using Studio

Regards