Ok, decided to post the files here since I can't attach files to PMs.
There are several files in the attached zip. The office files use macros, so you must have your security set to allow them to run. The directory is made using mail merges. Plenty of online help for that if you don't know how to run one.
Here is a description of the included files
1) Creating new directory2003.docx or Creating new directory2007.docx
These are instructions written for how to use the files and mail merge in the corresponding MS Office version.
2) ward directory export.mls
This is the custom report that is used to export info from MLS to use in the directory. Import this into your custom reports
3) ward directory export.csv
A sample export (from the test ward database)
4) ward merge info.xlsm
This file has a macro that I wrote that sees if the picture file exists. You can edit the path (in the cell formula) to point to where you keep pics. All the formula does is stick in a dummy photo (included) if the pic does not exist. This is also populated with test ward data.
Dummy picture file for those missing a picture.
6) Ward directory_template.docm
This is the actual merge document. It also has a macro - resize. Once you merge to new doc, you must copy the macro from the original document to the new document. Then, when you run the macro (after updating the links - in the instructions) it will automatically resize all the images.
The main trick is to have a link in your merge document that accepts a merge field as part of the link. This is what connects it to the pictures. The "codebreaker" for me was from this website
. I put all the pics in the same folder, and the merge field in the link is the preferred name (in the format last name, preferred name). All pics are named in the same convention (last name, preferred name.jpg)
This puts 25 people per page (I think)