Image fill in PrepareForm from Excel in MAC Adobe Pro DC

Question

hi all,I am about to create report for 500 students with marks.I created a excel file in Mac Numbers and exported to .TSV file and it perfectly filled up the fields in PDF. Now I want those students photo to be displayed in each report. 1. I Placed the photos in the same folder of that .TSV file, and given the path file for that photo, in a column in TSV file, and verified the properties name of that image filed and column header is same. but photo is not displaying, unless I chose it manually for each report.2. Can I populate 50 reports together?

try67 · Answer

The answer to both questions is by using a script to perform the Mail Merge operation, and to import the image files as the icons of your button fields. The latter can't be done in any other way, as an icon is not considered to be a value, so the built-in Mail Merge tool of Acrobat in Office won't import it, and neither will the built-in Import Form Data command (maybe only if you used a specially constructed FDF file, but not from a plain-text file).

This (paid-for) script I've developed will do it all, though. It can even automatically email the merged files to your students, if you wish. You can find it here:

https://www.try67.com/tool/acrobat-mail-merge-and-email-pdf-files

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded