I have written code that retrieves value in a cell and and inserts it into
a word doc. I also am using small business customer manager to mail merge
contact fields into the same word doc. i want the code to search for a value
in a specific merge field, find files within a specific drive that match
the value in that field, let me pick which file to open out of the alternatives
and then retrieve the value from a cell within that excel file and insert
it into the word doc. the problem i have now is that i can get a message
box to recognize the field but it does do anything. the excel code only
gets the cell from one particular file i need it to be more flexible and
use the search to recognize which file to pull the value from.