Want to set FormEmailer in the spreadsheet for two worksheets

[Ya-lun Hou]

I have a spreadsheets, that has two worksheets A and B. the content of B is selected from A(I use Data--> Named and protected ranges ).

I want when the form be submitted, worksheet A could send email automatically, I install FormEmailer to do that.

Worksheet B need to be fill some information and then to send the mail again.

But I can't set FormEmailer in the spreadsheet  for two worksheets.

Is there has any way to solve this situation?

[Firma MediaMarkt Straubing]

I have the same problem - but noone answers :(

[Rob]

I don't know of a direct way to do that with just formEmailer, but you could add an additional script to send information from the other worksheet.  Take a look at autocrat in the script gallery.