question about data from excel to work

[Pooja Kamdar]

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

 

[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.



--

Cheers

macropod

[Microsoft MVP - Word]





"Pooja Kamdar" wrote in message newsooja.Kamdar.5bf7a16@officefrustration.com...

>

> 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