Expression rule for Email Address

Certified Associate Developer

Hi All

I have a CDT  in which the data is saved liked that:

id interger 
name varchar
managerteamid integer
s1assigne varchar
s2assigne varchar
s3assigne varchar
s4assign varchar

Now I want to get email Address which is in this manager  Team id and all the assignees and then send the email to all . 

How to write the expression to find the email Address for that and also help me how to write in send email smart service ?

Thanks 

  Discussion posts and replies are publicly visible