Add, search & email

I have several tables in a db, and I'm wondering if the following is possible.

There is one table (recipes) to store user-entered information in several fields. There is another table (recipe requests) that stores user-entered info, and is basically a request list for info not currently in the first table. Basically when displayed it says, "This user is looking for this type of recipe".

The recipe insert query already sends a "thank you" email to the person that just made an entry. I'm wondering if, after a new recipe is entered & the email sent, the insert script can have a second query which will search the request table for requests similair to what was just entered, and send another email to the person that made the request telling them that a posible match was just entered.

Hope that wasn't too confusing.