Hi there

I'm setting up a workflow schedule based on my add employee form to email reminders annually on the employee's anniversary date/hire date. I want to remind the employee's manager to book the employee's annual performance review.

However, the fields I have on the form are the employee's email address and the employee's reporting manager, which means that I would need to fetch the reporting manager's email. How can I use the reporting manager's email address in the To: line of the notification in the workflow? In the send mail workflow is it possible to use look ups for the email fields? If I use $[email] it will send to the employee's email.

Thanks for your help.