How can I Import Photos from folder into Word and insert captions from elswhere.

[gillamtime]

This is my first time posting and I am an utter novice with Macros.

I have been given a task at work to compile a report each day, the report consists of a large amount of photos and comments about each photo. The format of the doc will be photo, then comment below. The idea is I take the photos then record my comments on maybe excel on my iphone whilst out on site and when it comes to compiling the report I can put these two sources together quickly with a couple of macros.

I have found a few helpful macros which call in the photos and resize them but I can't find a way to bring in the comments. Any help on creating this macro would be greatly appreciated as my brain isn't naturally inclined toward these things. Thanks

[gmayor]

Take a look at http://www.gmayor.com/photo_gallery_template.html, which does more or less what you ask from an Excel worksheet. This uses a configurable table to hold and fix the sizes of the images with the captions underneath. It was designed especially for this type of task.

If you put the filenames and paths and the associated comments as individual records in an Excel worksheet, you can mail merge the images and comments - see http://www.gmayor.com/mail_merge_graphics.htm and http://www.gmayor.com/mail_merge_graphics_addin.htm.

[gillamtime]

Hi Graham

Thanks for the reply and thanks for making a great tool, I have used the photo gallery template tool and got this working for the most part, the only thing I am unsure of is how to resize the photos without having them over two columns. Is there any way of having it fill a column down the left only whilst reducing the size of the photos, so far the only way i have found which makes the picture smaller is to have the pictures in two columns.

Thanks

[gmayor]

The pictures as you have realised are sized to the width of the table cell. The table is created to fit the space between the page margins. If you want a narrower table, reduce the space between the margins in the section used for the table.