So, I am trying to save myself some hassel in switching between data in excel and word.


Specifically, I have a letter in word, and a database of names and fax numbers in excel. I want to be able to import the fax number from excel by just typing in the name, or something like that. I'm not wanting to do a mail merge or anything, I just want one piece of data (out of thousands) to be imported.

Any help/direction is greatly appreciated!

Link or embed an Excel worksheet .ACICollapsed { display: none; } .ACECollapsed { display: none; } table { word-break:break-all; } Here's a tip from Word help. I hope it helps.

Link or embed an Excel worksheet




When you want to create a dynamic link between the content of your document and the content in a Microsoft Office Excel workbook, insert the content as an object. Unlike when you paste content (such as by pressing CTRL+V), when you insert it as a linked or embedded object, you can work with it in the original program.
If you insert the cells into the document as an Excel object, Microsoft Office Word runs Excel when you double-click the cells, and you can use Excel commands to work with the worksheet content.
When you insert an entire Excel workbook as an object, the document displays only one worksheet. To display different worksheets, double-click the Excel object, and then click the worksheet that you want.