Add text from sheet to pictures (Mail merge style)

Hello all,

I currently have a sheet (attached) which contains data about pictures I have taken, the data is picture file name, product no, dimensions, what I am trying to do is add the text in the sheet onto the coresponding picture (not the details of the pic but actually over the picture), a bit like a mail merge. All the images will be stored in the same directory i.e. c:\\my documents\images.

I know there are programs that work on the camera side to do this one by one but I have some 16,000 images that need to have this data added am looking for a way of automating it.

The last part is to save the new pic as the product number, but I think this is quite easy using a macro.

Has anybody got a creative mind? as I think this is what this solution requires. Any help on this would be much appreciated.

Regards,

North

Shot in the dark, and maybe someone who knows more than I do will come along with a better solution, but it seems like you might be able to do this with some creative use of Photoshop macros and/or AutoIt. I haven't done this though, so I can't offer any more help.

http://www.autoitscript.com/autoit3/

Thanks for the idea, I will have a look when I get home.

An idea that I have come across is actually to use the mail merge to directory function, I am currently playing with this to see if I can adpat it to suit my needs, just need to find away of grouping the fields and image together and then save as jpeg!

Any other ideas anyone?

Regards,

North