A kind of mail merge issue

[SkydiveMacca]

Hello all,

 

Not sure if this is the best place to ask, but I need some help.

 

SLT have a big master spread sheet of data, with a few tabs. They create one of these for each term.

 

I need a way to take some of the information from the spread sheet and merge into a printable document, with each page containing data for each individual pupil. So if the spreadsheet had 20 pupils on it, the final document created has 20 pages, with 1 pupil on each.

 

I know I can mail merge this, but they want to be able to do it themselves and they are truly limited in IT knowledge. Can I set up a mail merge 'template' of sorts?

 

I had a quick look at Google Docs (they're big fans) and while I can merge from sheets to a template doc, the ways i've found creates 4 separate docs, which then become a PITA to print out.

 

HELP! Hair, rapidly being pulled out.

 

 

Thanks in advance

[unixman_again]

We do something similar with our online application system. Applications are written to a MySql Db which is then extracted to a spreadsheet (one sheet). I have a macro which explodes this sheet, to one per student and calculates application scores. The macro was quite easy to write and they can fiddle with the master sheet, press the button and all the exploded sheets are all recalculated at the click of a button, cunning labelled "Press".