Hi, I posted a similar question to the user above just now.
I am also having trouble figuring out how to have a copy of the form submission sent to users based upon a drop down selection.
You mention using an email data connection, but that confused me as I thought that data connection referred to where the data went, and my data connection is a SharePoint List.
I saw the Data Connection Wizard and the screen in which one enters emails, but I don't quite understand what the formula would be. I don't have the email as a "form field" as you mention.
Thanks in advance for your help.