initiate the Excel worksheet that contains the data you want to link to the Word document.
In Excel,select and copy the range of cellsto include.
grab the entire worksheet if you plan to insert more columns or rows into the worksheet.
In the Word document, position the cursor where you want to insert the linked table.
Right-click and selectLink & Use Destination StylesorLink & Keep Source Formatting.
Destination Styles uses the default Word table formatting, which usually results in a better-looking table.
Keep Source Formatting uses the formatting from the Excel workbook.
The Excel data pastes directly into the Word document where the cursor was positioned.
If changes are made to the source Excel file, the Word document updates with those changes automatically.
It is a one-way link feed that brings the updated Excel data into the linked Word document.
There are two ways to embed an Excel worksheet in Word.
The first is to embed the worksheet as an object.
The second is to insert a table.
When you embed a worksheet, Word uses the formatting from the Excel worksheet.
confirm that the data in the worksheet looks the way you want it to appear in the Word document.
In Word 2010, selectInsert>Object.
In theObjectdialog box, select theCreate from Filetab.
SelectBrowse, then choose the Excel worksheet that contains the data you want to embed.
The Excel worksheet is embedded in the Word document.
This method inserts the worksheet as if you embedded it as an object.
The difference is that it opens a blank Excel worksheet for you to fill out.
Choose this method if you haven’t created the Excel file yet.
To insert an Excel worksheet as atable in Word:
Open a Word document.
Place the cursor where you want to insert the Excel worksheet.
Go to theInserttab, then selectTable.
This menu option opens a blank Excel worksheet you might fill with data.
Either enter new data or paste data from another spreadsheet.
The data in the Word table automatically updates to match the data in the Excel file.
FAQ
In Excel:Inserttab >Text>Object>Create from File.
Next, selectBrowseto find the Word file >Insert>OK.
Then, chooseSelect Recipients>Use an Existing List> find the Excel address list >OK.
Add the merge mail fields to complete the merge.
