yes
, i see that solution works but i dont want to have to down load a file, or 3 everyday for a small range where only some data changes.
I can add the range manualy using copy and paste but that seems a bit pointless as i use the app to fill in a line of info, the spreed sheet processes it and the results reported in different tables.
want i want is after pressing submit the email app is launched and the data from
the appropriate table added to the email body,