First, I want to say that I love Form Emailer! Thank you for creating such a wonderful script to make Google Forms so very powerful.
I created a student behavior tracking form. When a teacher submits the form, an email is sent to me, the counselor, and the other principal. However, the Sent From is always my name and email, giving the impression that I am the one submitting the form. In the body of the email, it reflects the actual teacher name. The Sender Name field settings is set to #Your Name# from the form. The email address shows as mine, but when I hit reply, the teacher's actual email address shows.
Is there a way for the From and email address shown to be from the actual sender and not me?
I hope this makes sense.