question about data from excel to work

I am trying to take input from an excel sheet and mailmerge it to word....the thing is I want to make it so from here on out ..if I change something in the excel sheet it automatically updates on word as well..if not a mail merger what can I use ?

Hi Pooja Kamdar,

You can link the Word document to the Excel workbook, so that any changes in the Excel workbook will be reflected in the Word
document. To do this:
1. copy the source range in the Excel workbook
2. in the Word document, use Edit|Paste Special Paste Link and choose the paste format you want to use.
In Word, you have the option to set a 'update automatic links at open' setting, which will ensure the Word document always opens
with the latest updates to the Excel workbook.

--
Cheers
macropod
[Microsoft MVP - Word]


"Pooja Kamdar" wrote in message ...

I am trying to take input from an excel sheet and mailmerge it to
word....the thing is I want to make it so from here on out ..if I change
something in the excel sheet it automatically updates on word as
well..if not a mail merger what can I use ?




--
Pooja Kamdar