Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If I were to create an excel sheet with merge fields for a Mail Merge, and one of those fields were to be a file location, for example, can I then create a link in my Word document to a second Excel file based on the file name / location in the Mail Merge field?

Links pointing to documentation on this subject are equally appreciated.

share|improve this question
up vote 0 down vote accepted

You can insert a Hyperlink into the Word document in the normal way and set the display text to whatever you want.

Highlight the hyperlink and use Shift + F9 to see the field code.

{HYPERLINK "C:\\path\\to\\excelfile.xls"}

Replace the part in quotes with the merge field name.

{HYPERLINK "«Link_Path»"}

Use Shift + F9 to switch back to normal view.

share|improve this answer
Right on! Actually {LINK ... } was what I needed (I think), thanks for your input. Now on to understanding the switches ("\a \f 4 \h").... – Mendel Jan 2 '13 at 19:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.