My issue has been resolved for some magical reason!
Line of action:
- opened document
- opened formmule
- nothing there, so need to re-add all sheets with info, triggers etc. (Sigh)
- pull down menu and add "sheet to get email addresses and other merge info"
- click sheet I need, i.e. same one as before
- click to save and go to next step
- magically all my triggers and sheets matched up EXCEPT for one sheet, which had duplicated itself and renamed itself with the same name yet with the word "TEMPLATE" at the end.
- I deleted the word "TEMPLATE", so the sheet regained it's exact original name
- clicked save, save etc.
- Everything worked
- I went and got a coffee, and smiled to myself, wondering about lifes big mysteries.....
Have a great day!