If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 ?
|
#2
|
|||
|
|||
question about data from excel to work
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 |
Thread Tools | |
Display Modes | |
|
|