question about data from excel to work

[Pooja Kamdar]

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

 

[macropod]

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.