generating an email template based on cell content (text)

[Blanchetdb]

Hi,

This what I am trying to accomplish but unable to make work

I have a spreadsheet that has a number of cells (it has drop down options) that a person would select. Based on the selection, an email would be generated to a specific email address.

example:

Cell F10 - if selection is "yes" or "oui" then an email is sent to John.smith@hotmail.ca
Cell J14 - If selection is "Obtained" or "Acquise" then an email is sent to Paul.LeBlanc@hotmail.ca
Cell A5 - If selected / All Information contained in Cell A23:K23, A24:K24, A26:I26, A27:I27 is emailed to Susan.smith@hotmail.ca

can something like this be done?

needing help

thank you