get user email from connected to employee id that is

[megatronixs]

Hi all,

I have a list in excel where all the employees are listed. I need to get the email address from the team leader based on the employee id from one of the team members.
How could I get this like in below example:
John Doo, 123456789, Peter Cetera, 289276254, peter.cetera@hisEmail.com

It seems I would need to link the name of the team leader and find his employee id, and then find his email address or just find his email address connected to his name.

Any suggestions?

Greetings.

 

[Ranman256]

First, your data should be stored as:
John Doo, 123456789, John@email.com
Peter Cetera, 289276254, peter.cetera@hisEmail.com

then get the email via query or Dlookup:
vEmail = dlookup("","tEmails","[id]='" & me.ID & "'")

 

[megatronixs]

hi Ranman256,

thanks a lot, it is working

Greetings.