is there a ready to use solution for an automated eMail notification system for frontend users (not backend users) which sends an eMail each time a new resource is published?
Usecase: I am planning to offer a “subscribe to this category” form on the frontend, in which a user can type his eMail. The categories are just parent resources. Each time a child resource is published, the subscribers should receive an eMail which states “dear user, we have new content in the category you like”.
I don’t want to use third party tools.
For the subscription part: custom db table, formit2db (i only need to fetch the eMail + parent ID of viewed article (=the “category”), double opt in via email with “activation” of the subscriber in the db, custom CMP to manage the subscribers. (Other / better ideas welcome)
For the automated eMail sending process: I need to fetch the subscribers’ eMail addresses from my custom db - according to the parent ID (the “category” they are interested in) of each new published resource - and then automatically send an eMail to them.
What is the best practice to sending that eMail? Use Formit in a plugin? ModMail?
Please note: I don’t want the eMail to get send each time a resource is updated - only when it is published for the first time.