What you could try is:
Find with a GREP all product numbers. Change (also with GREP) to the
full URL that you need -- I presume this is simply a question of adding
some sort of URL prefix to the product number.
Then run InDesign's automatic "Create hyperlinks" command.
Then GREP out the URL part again, leaving only the original product
number (easy to do if you gave it a different color or something initially).
If that doesn't work, sounds like you would need a script.
I would suggest:
1. Import the Excelfile into the 200 page document
2. run the script and pick up a productnumber and the correspondingURL from the imported table
3. search the productnumber by a GREP command
4. create the hyperlink
5. next productnumber / URL from the list
Hope this helps
If you are still looking for a solution, we have one that handles this and a whole lot more. One of our specialty areas is catalog production, and this is a relatively common request. Please check out www.meadowsps.com/pdfexporter for more information.
Checked out your website and this sounds like exactly what we need, John. I will e-mail your sales team as soon as possible.
Thanks for the reply, and for the email. You don't need to have AutoPrice for this, but if you do that certainly helps with the initial setup. You might also find some benefit by using AutoPrice (automatic price updates; catalog versioning, etc.).
Our sales team a can answer any questions you may have, and perhaps set up a webinar demonstration for you.
Thanks so much for your interest in our software!
UPDATE: Found a script for a part of this workflow. Not fully automated, but it's speeding things up a bit. The script takes a tab delimited list in a .txt file and uses it to create a bunch of hyperlinks all at once.