Ok so I tried played about with this macro this morning and it is outputting to the correct location in the correct format (JPEG) with the correct file names, unfortunately the name field within the pictures all read "Name" though instead of the name from the spreadsheet and I can't see a way to fix that.
I have attached a JPG output and the publisher file in a compressed folder.
Thanks for any further help
Tim
|