Prev: Where is the product key located on Acer Aspire?
Next: When I preview my web site before publishing it is not centered
From: Pooja Kamdar on 15 Feb 2010 15:10

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
From: macropod on 15 Feb 2010 18:47
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(a)officefrustration.com> wrote in message news:Pooja.Kamdar.5bf7a16(a)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

 | 
Pages: 1
Prev: Where is the product key located on Acer Aspire?
Next: When I preview my web site before publishing it is not centered