I'm not sure this is possible. Anyways, here is what I am trying to accomplish.



I have a word document that is populated using reference links from an excel file. Part of this document is a breakdown of the economic conditions at the time, which is dependent on what date is entered into my excel file. The economic conditions write ups are produced quarterly and stored in a separate word file. We currently manually copy and paste the text from the apropriate file into our document.

So for instance, if the date entered into the excel file is January 31, 2013, we would currently manually enter the text from the Q1 - 2013 word document we have saved in a separate file. If the date was November 30, 2012, we would copy and paste the text from the Q4 - 2012 word document and so on.

My question ultimately is, is there anyway to populate the text from the Q1-2013 word document into our linked word document based on the input in the excel file?

What I would like to happen is the user can put in a date, and based on the date, the text of the quarterly economic conditions word document be updated in our linked word document?

The text in the quarterly word docs is far too long to attempt to re-type into a concatenation formula.

I hope this makes sense, however I'm not sure it's possible.

Any help is greatly appreciated!

Thanks!

JM