I'm just starting to work with the SugarCRM product and am trying to figure out if there is a way to create a Workflow that is trigged based on the Due Date of a Task.

My ultimate goal is to try and create a workflow that sends a weekly email for each Salesperson listing all Tasks with Due Dates for the following week.

Does anyone have any insignt on how I might accomplish this?