Sending individual mail to manager with concatenating compnay mail id to manager name

[kritikamish99]

Dear all,

I have two table 
Table 1 :

Employee name	Manager name
A	ABC
B	BCD
C	CDE
D	CDE
E	HIJ
F	EFG
G	HIJ

Table 2 :

Employee name	Manager name
A	ABC
B	BCD
D	CDE
G	HIJ
F	EFG

In the above case Manager name "CDE" and "HIJ" does not have employee "C" and "E" from table 1. So i need to create emails notification where i can write mail to manager "CDE" and "HIJ" stating your employee "C" and "E" has left the organisation kindly delete the data from backend . The mail to manager will be sent individually with their Employee name in mail body. 

Please note  : i dont have email id of Manager and i need to add "@companymail.com" after Manager name to send mail to manager other wise it failing .for example  : CDE@companymail.com  

[ChrisTX]

This looks like a simple Join, then a Formula to create a field for Manager email address, then use the Email tool.

What have you tried so far?  Or do you just not know where to start?

[kritikamish99]

it got it resolved .
I just used filter and added column with manager +"@companymail.com"
and it created column which i was able to add into Email tool.