A user can login to my site and is presented with a form to complete. The form contains a Category drop down, and then 5 possible text fields with a Task Name and a Completion Date within that category. When the user makes changes and saves, the data is placed onto their profile - from the Wordpress Edit User screen I can see the Category, Task Names and Completion Dates.
I would like to run a process daily that looks through every user profile and, for a user with a completion date 1 week away, sends that an email w/ the task name.
I also want to embed an image and text, including links, in the email based on the Category Name.
Any help or guidance is much appreciated, point me in the direction of how something like this would be handled and I'll start researching!!