importing data into a Word document

  • Thread starter Thread starter biff
  • Start date Start date
B

biff

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?
 
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.
 
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.
 
Back
Top