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
