importing data into a Word document

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?
 
J

JLatham

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.
 
M

macropod

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top