I am not sure if you are familiar with the following. I am trying to create a dropdown list/menu in word and have it populate data from excel without opening excel. I read that this was possible but I have no clue how to get it done. I created the dropdown list in word and I have a xls spreadsheet to pull from but I don't one a meilmerge. With a meilgerge I have to open excel and I don't want that.

Do you have a clue how this can be done?

Thanks,

Sandra