printing pdf hyperlinks

[Jeff-Q]

I have a spreadsheet with a large range of data that includes hyperlinks to pdf files. A Word document links to information in this spreadsheet and a report is printed. I'd like to add a feature to the report that prints the hyperlinked PDF files that are associated with the reported excel data. Does anyone know how I might accomplish this.

To summarize: I want to print a MS Word document that contains data linked to Excel (no problem). In the excel spreadsheet, there is a hyperlink to a pdf file for each data item. I'd like the reported data specific hyperlinked pdf files to print with the word report.

Example Excel sheet:

-colA----colB-----colC-----colD
data1 data1b data1c data1.pdf (hyperlink)
data2 data2b data2c data2.pdf
data3 data3b data3c data3.pdf
data4 data4b data4c data4.pdf
...

Example Word Report:

[PAGE1]
Report List

data4......data4c
data1......data1c
data3......data3c
-----------------------------------
[PAGE2]
c:\mydocs\data4.pdf (not necessarily embedded as an image in word, although that would be acceptable, but I just would like this to print after the report. This word report is a template that changes based on changes to the excel spreadsheet.)
-----------------------------------
[PAGE3]
c:\mydocs\data1.pdf
-----------------------------------
[PAGE4]
c:\mydocs\data3.pdf


Any suggestions or help is very much appreciated.

Thanks,

Jeff

 

[McQuinge]

I hope someone can see this post and come with some suggestions.
I'm having the same challenge.