Scripts in E-mail recipient fields

  • Hi

    Can you enter scripts into the e-mail recipient fields to return a user?

    I want to use the Send E-mail functionality in my Lead Workflow, whenever leads get re-assigned, to notify the relevant Territory Manager that leads have been reassigned to their Sales Consultants. 

    To illustrate what I want  to achieve, the logic would be something like this: (excuse my syntax ^^, still new to this)

    select user_id

    where (user_channelid = "Managers" AND user_secterr = lead_secterr)

  • Would this be similar to your requirement?