ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   importing data into a Word document (https://www.excelbanter.com/excel-discussion-misc-queries/255965-importing-data-into-word-document.html)

Biff

importing data into a Word document
 
Say you have a Word document that is setup like a form in that it has lines
for people to input data. It is technically not a form in that you don't
click into a box and type data. Rather the blank lines indicate people
should input something there.

Is there a way to take data from a Excel file and import that data into the
Word file in specific locations? If so would there have to be some
formatting done to the locations where the data would import into?



JLatham

importing data into a Word document
 
Look at Word help for Mail Merge file creation with Excel as the data source.
I think that might be helpful to you in this instance. But I could be wrong.

"biff" wrote:

Say you have a Word document that is setup like a form in that it has lines
for people to input data. It is technically not a form in that you don't
click into a box and type data. Rather the blank lines indicate people
should input something there.

Is there a way to take data from a Excel file and import that data into the
Word file in specific locations? If so would there have to be some
formatting done to the locations where the data would import into?



macropod[_2_]

importing data into a Word document
 
Hi biff,

If you're trying to generate a series of form letters or something such from the Excel data, Word's mailmerge feature is probably
what you're after.

If you're trying to link Word to the value of a particular cell or range in Excel, so that the Word data updates whenever the Excel
data change, copying from Excel, then using 'Edit|Paste Special Link' in Word may be what you're after.


--
Cheers
macropod
[Microsoft MVP - Word]


"biff" wrote in message ...
Say you have a Word document that is setup like a form in that it has lines
for people to input data. It is technically not a form in that you don't
click into a box and type data. Rather the blank lines indicate people
should input something there.

Is there a way to take data from a Excel file and import that data into the
Word file in specific locations? If so would there have to be some
formatting done to the locations where the data would import into?





All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com