Hi, 

We have a use case that requires sending email notifications on defined intervals from Deals module. The Deals module has a lookup field linked to a Custom Module (Group). Each record in Group module has some fields linked to Contacts module to represent the people who are part of that Group for example. CEO and CFO. 

Problem:

The Contact in Group module are recipients of the notification that needs to be generated from Deals Module. When we configure a workflow rule in Deals module, it allows us to link a field of type Email from Group module as recipient but doesn't allow us to go one level deeper in the association hierarchy and let us select the Email from those Contacts (CFO, CEO) instead. 

How can we configure the workflow to include the following as recipient of email notification from Deals module:

                                           Deals -> Group -> CFO -> Email

We'd appreciate any assistance in this matter.