Hi all,
This is a speculative idea for a project I am working on for staff at three local schools.
I have a set of data from a google form about staff understanding of different ICT tools/skills. E.g. Saving documents as a PDF, with the answer rated:
Very Confident
Confident
Unconfident - would like training
Very unconfident - training priority
I have written a page in word (have a .docx and .pdf copy) to support staff for each of the 50 tools/skills I surveyed.
I would like to create custom 'packs' for staff based on their responses in the survey. i.e. if they entered unconfident for 20 of the tools/skills they will receive a pack that has the sheets only for those tools/skills.
There's 800 staff in total so manually creating these packs is unlikely to be possible, so I'm interested to know if this is at all possible, or if it is a crazy idea.
Your advice is much appreciated.
Luke
(cross posted: http://www.excelforum.com/excel-general/1089986-is-this-possible-mail-merge-vba-to-merge-pdfs-into-one-document-based-on-cell-values.html#post4111354)
This is a speculative idea for a project I am working on for staff at three local schools.
I have a set of data from a google form about staff understanding of different ICT tools/skills. E.g. Saving documents as a PDF, with the answer rated:
Very Confident
Confident
Unconfident - would like training
Very unconfident - training priority
I have written a page in word (have a .docx and .pdf copy) to support staff for each of the 50 tools/skills I surveyed.
I would like to create custom 'packs' for staff based on their responses in the survey. i.e. if they entered unconfident for 20 of the tools/skills they will receive a pack that has the sheets only for those tools/skills.
There's 800 staff in total so manually creating these packs is unlikely to be possible, so I'm interested to know if this is at all possible, or if it is a crazy idea.
Your advice is much appreciated.
Luke
(cross posted: http://www.excelforum.com/excel-general/1089986-is-this-possible-mail-merge-vba-to-merge-pdfs-into-one-document-based-on-cell-values.html#post4111354)