I have a database collection named dbtsAddresses that has a field that stores a customer’s email address (emailAddress) and a field that stores the date of their installation (dateOfInstall), among others.
I want to be able to send an email to the customer’s email address a certain amount of time after the dateOfInstall (ie, 10 months) with a pre-written email that just fills in the necessary information with the data from the other fields.
I was wondering if there is any way to do this? I’ve looked into using automations, but it doesn’t seem like that will work because I want to base when the email is sent off of a database field, but I’m happy to be told otherwise. I don’t know of any way to do this and was hoping for some suggestions or recommendations of what can do this so I can research further.