AnsweredAssumed Answered

How do I dynamically set the mail connector to field using a database field?

Question asked by JacobLangston9181 on Mar 13, 2013
Latest reply on Mar 14, 2013 by JacobLangston9181
I need to send notifications to team leaders in my organization if a task has not been completed in the last 30 days.  If a task has not been completed in 30 days an email message should be sent notifying the team leader that the task is stale.  I have written a SQL query that returns all of the pertinent information, incuding the email address of the team lead to notify.  I need to be able to dynamically set the to field of the mail message to be sent.  How can this be accomplished?