• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

question about data from excel to work

P

Pooja Kamdar

Flightless Bird
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
 
M

macropod

Flightless Bird
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" <Pooja.Kamdar.5bf7a16@officefrustration.com> wrote in message news:pooja.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
 
Top