Extract pages based on names on excel spreadsheet

Question

Is there a way to build basically a vlookup between a pdf and an excel lit?  I have active and terminated employees W2C documents on a very large pdf.  I only need to print the terminated employee's W2C but there are 650 of them and I don't want to look them up one at a time.  Is there an automated way to do this?  I'm also not opposed to extracting only the terminated employees and putting their documents in their own pdf file.

try67 · Answer

It is possible, but it's complicated. For starters, you can't read the data from the Excel file directly. You'll have to save it first as a plain-text file. Then it would require the development of a custom-made script to read the data from it and extract the pages from the file based on that data.

I've developed similar tools in the past for my clients so if you're interested in hiring someone to do it for you feel free to contact me privately via [try6767 at gmail.com] to discuss it further.

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