Seriously...Excel/Word experts only, I'm amazed no one can find the answer on this!

I'm really amazed that no one can come up with a solution on this one...

I set up a hyperlink in Excel that points to a Word Doc, the only problem is that is doesn't open up it up the same way as just double clicking on the file itself or opening it up in Word.

How you ask?

Well, I have a large contact list and each file goes to a certain pre-selected contact which is saved that way. When I open up the file from within Word or double click the file itself, the recipient's name shows (the email toolbar button is selected automatically), but when I click on the Hyperlink in Excel, the Word doc opens up without the email button selected by default and without the recipients name there. This forces me to then click on the email button to bring this information up.

Anyone know of a way to have the email information automatically selected when opening up a hyperlink in Excel to a Word doc?

Does Excel have a way of using shortcuts instead? Maybe a shorcut to a Word Doc will open it in up the same way as Word will.
Thanks in advance.



A RESPONSE FROM AN EXPERT WORD USER IS BELOW, CAN YOU EXCEL EXPERTS COMBINE THE INFO ABOVE AND BELOW TO COME UP WITH A SOLUTION?



I think you'd need to create buttons linked to macro code that opens the
documents. It would be best to start on this from an Excel newsgroup
(excel.programming), as they can tell you which buttons are best to use and how
to assign a macro to them.

Ideally, you'd use the same macro for each button. There'd be something about
the button (the caption, or a "tag") you can use to identify which button /
document has been clicked. The macro can check this, then open the correct
document. So you should also mention you need to know this.

The Excel folks may also be able to give you the code to open the Word
documents.


Please try your best! Thanks everyone!

Let me make myself very clear, I would never try and degrade any users who take their free and valuable time to help us "non-pros" out. I have a great deal of respect and greatly value any input I get from anyone, including you Bryan. As a matter of fact, you gave me some help on previous posts to which I am grateful for. So I respectfully ask that you do not put words in my mouth.

Having said that, even if my Excel problem cannot be solved and someone believes this to be true, I would ask that you please respond by saying this cannot be done if this is indeed what you believe.

Thanks.