Staff Data Collection sheet - can email? SOLVED

[coolhands]

We have a staff data collection sheet downloaded from somewhere that outputs as a RTF and opens in word. My simple question is this - is it possible to email staff their data collection sheet somehow, so they can review it? I'm going round in circles. All staff have their school email in the appropriate field in sims. The report outputs as one long document ie all staff on it on separate pages. Fine if you are going to print them and hand out but obviously it would make sense to email this type of thing.

 

I have got YAMM (yet another mail merge) as I though this would help but then realised it still doesn't help as you would need each data collection sheet saved as separate file in your (google) drive. Which I can't do. Also each one would have to have identifiable file name.

 

we have edulink too - can I do something through that?

 

ok to answer my own question and help anyone else in the future - I changed sims report to output as excel. Then copy that to googlespreadhseet. Use YAMM (an add-on that you have to pay for, free version has fewer daily allowance, it is used for gmail and uses google sheets) to create a mail merge email that puts each field into the email which can be sent to all staff. Each staff member gets an email with their own info in it to check, and can email me any changes.

Edited November 5, 2020 by coolhands