Hi,
I have the following scenario:
I want to mass-produce some cards (like quiz cards in trivial pursuit), and I have made a image (card template) in Photoshop that I want to import information to, from a excel book, that have 3 sheets in it. I have the textfields that the information should go, also sat up in place on this template.
I want cell A1 from sheet 1, cell A1 from sheet 2, and cell A1 from sheet 3 imported into this card layout, in 3 different text-fields, 1 field for each cell-content. So there will be 3 quiz questions on each card.
After that i want to make a serial number in another textfield, going from 001 and up (this is not mandatory, but would be nice).
When all that have been done, i want the card to be exported/saved as a PNG with the serial number as the image name.
After that i want the loop to continue, importing B1 in sheet 1, B1 in sheet 2 and B1 in sheet 3.........
Did I explain this good enough? Is this possible, or do i have to do this manually - with almost 1000 cards... ? |
