Send emails to contacts who are in another table

Hello people!

I’m new to AppSheet and I’m creating an app for testing, but several questions are coming up, one of which is about sending email.

I have two tables, one called “Visitor” and another called “Reception”.

The situation is as follows: When I register a new visitor, I need an email to be sent to one of the emails registered in the “Reception” table.

Example: The visitor named Jhon will be registered at the concierge informing his data and where he is going, for example, he will go to building nº 03. When the porter adds his data, the receptionist of building 03, who is registered in the app, will receive in his email that João is arriving.

How can I do this? Can someone help me?