I have lots of data rows in excel, each row has columns such as first name, last name, gender…etc.
I also have an image as the template, I would like to define some placeholders on it. And then for each data row, an image will be generated by filling its data items into these placeholders.
Finally, all these images will be combined as a single pdf (one image per page).
Is there any software application that can do such thing?
Note: while placing the image as the background/watermark in ms word and then using mail merge may work, one big limitation is that, it's difficult to achieve absolute positioning with merge fields. This is why I am looking for other possible solutions.
Best Answer
This article should give you what you need. you will just have to create a PDF form using the image you have. the procedure there creates new PDF for each entry. You will be able to modify it to get all entries in one PDF. If you cant, I'll help you with that part.
EDIT
I think I finally got this. Go the mail merge way.
Make your picture behind text as written in my previous comment. After that, Go to "Insert"->"Shapes"->"Textbox" and insert and arrange the textbox on top of your image.
The advantage of this is you can drag the textbox freely around the document. This will rid you of the pain of using spaces and tabs to adjust text position.
Then use mail merge and merge data from excel with the textboxes.
Finally, there's a simple free add-on that lets you to save to PDF directly from word. Find it here.
I hope this solves your problem.