Send Email to Opportunity Team member
I want to send an email to an opportunity team member with team role = "Inside Sales" when the owner of opportunity adds the team member. One way of doing this is
Record Type : Opportunity
Trigger Event:When Modified Record Saved
Workflow condition : Sales stage = "Quotation Assigned"
Action : Send Email
To: Relative User on record : Opportunity Team - Inside sales.
However I want to avoid an extra sales stage"Quotation Assigned" just to triggger a notification to e sent to the team member. I was wondering if i can acheive this requirement by triggering the event on Opportunity team member object itself. The hurdle I am having is building the To using the function. Is it possible to use joinfield values and get the email address of the Team member. To my knowledge JoinFieldvalue ('<User>', [<OwnerId>],'<EmailAddr>') - grabs the record owner email address but how do I get the team member's email address. Any idea?