I am still experimenting with the best way to add photos myself and there are probably others with a more elegant technique.
Right now, I have my camera set to lowest rez settings, and I try to fill the screen with the patient's face when I take the shot, so you can recognize them when it's reduced.
This is still producing a pretty big file, so later we open the pics with Microsoft Office Picture Manager (which came with Office, I suppose).
If you have that, you can click on the "Edit Pictures" tab, then "Compress Pictures" and get them down to "E-mail message" size, which is 13K. Save, and rename. Delete originals. It is clunky, I know, but you don't want to clog your database with memory-intensive images.
I had thought about experimenting with some of these freeware programs designed specifically for batch image resizing, but I am a little paranoid about freeware & shareware:
http://www.softpedia.com/get/Multimedia/Graphic/Image-Convertors/Avatar-Sizer.shtmlIf you scroll down the page, there is a whole list of freeware batch photo sizers, but I have not tried any of them. Maybe someone else has.
Or perhaps you have a sacrificial computer, and you would be willing to experiment with each of them, Zak, for the sake of the entire Amazing Charts family! ;-)
Good luck
Brian