We have a contribution page that creates automated recurring contributions on a yearly basis.
Because 12 months is a long time to remember that you have a recurring contribution set up, we want to send out a courtesy email 2 weeks before to let people know that we are going to take a payment and give them the opportunity to cancel it if they want to.
Is anyone else doing this? How do you do it? A scheduled reminder based on
civicrm_contribution_recur.next_sched_contribution_date would be nice but I know that isn't possible at the mo. Are there any other ways people are doing this?
PS. I know that we could use membership end date if they were members but we don't want to go down that route - we want to tie it to the recurring contribution.