Hi All,

I have been stumped by a problem and have been wondering on whether a solution is possible.

I have a word document which I have made references to other documents that I have saved as PDF's in the footnotes of the document. Now I want to insert hyperlinks whereever these documents have been referenced. I am trying to automate this process to avoid having to repeat the process is required again.

The approach I am taking is to save the reference and the hyperlink in excel and I am trying to use this data to create the hyperlinking. So say I have the following saved in excel:

Document: Path:
0110_00001 \0110_00001.pdf

What I am trying to acheive is to check if the document name appears anywhere within my word document and if so insert a hyperlink for the found text and have the path above as the hyperlink.

Any help or guidance in the right direction would be greatly appreciated.

Thanks in advance.