See how simple it is to turn your data into a yearbook
Once everybody has entered their data for the yearbook, you can simply download it as a spreadsheet. Then, just merge this into the template to produce your pages.
Included in the example is:
- The template for the pages.
- The data as a spreadsheet.
- The photos for each person.
When downloading from the online database, you will receive a similar file with the spreadsheet and photos, which you can use with your template. So, with the example files:
- Extract all the files into the same folder. There should now be Template.doc, data.csv and a folder called photos.
- Open the template document, Template.doc.
- Go to Tools, Macro, Macros..., make sure mergeData is selected, and press Run.
You should now have some example pages!
In some version of Microsoft Word, you may need to click on Enable Macros when you open the template.