Atomation email to a Contact

[SEUAdmin]

I have a Contact list Table with [name], [email], [phone number], [title], [company].

I have a table for Jobs to be assigned and track completions. Jobs table have a [Job Owner] column, and assigned [Worker] column,  both referenced from Contacts Table.

I wanna create an automation that when a Job gets completed, emails the completion to the Job Owner.

can someone help me please to figure out this?

[Marc_Dillon]

What part do you need help on? Building the Bot? Or assigning the email recipient?

[SEUAdmin]

Assigning the email recipient 

[Marc_Dillon]

You put the column that has the email address into the "To" field.

[SEUAdmin]

hey Marc, that is obvious, everyone know where it goes, I needed a formula to place it at "To", as an expression to send an auto mate email on a valid condition and to an specific person.

We figured it out. We appreciate your intent.