Programming Script to combine tif batches to ONE PDF File and name that ONE PDF file as record number (see details)

OK, here goes.

I have about 10,000 tif files with filenames like: "dvf48483.tif , dvf48484.tif, dvf48498.tif, etc" (all in random) in a folder (Say C:\Charts)
Now there's a bunch of tif files that could be part of the same record, like the above 3 could be a part of record '17010916', and then there could be 12 other tif's that are part of another record and so on...

Now I have an excel CSV file (called output.csv) that has this info (i.e., what tif files go under which record number), like:

Col A                   Col B
                          17010916
@dvf48483.tif          
@dvf48484.tif
@dvf48485.tif
@dvf48486.tif
@dvf48487.tif


                         17107409
@dvf48496.tif
@dvf48497.tif
@dvf48498.tif
@dvf48499.tif
@dvf48500.tif
@dvf48501.tif
@dvf48502.tif
@dvf48503.tif
@dvf48504.tif

and so on....

Here's what I want to be able to do (and something that's urgent)

I want to COMBINE all the tif files that represent their record number (from Col B) into ONE PDF file, and the filename of that PDF should be that particular record number.

So from the above example, the tif files from the first batch will combine together to form ONE PDF which will be called 17010916.PDF, and then the next batch will be combined to ONE PDF called 17107409.PDF, and so on... (Let's say all these PDFs can be stored in another directory like C:\Charts\PDF)

So experts, think there's a script that can do this? If so, can you tell me how I would apply it, what extension should I save it as, and exactly how I would run it?

Please assist.

Thanks.

Start Free Trial