Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Resolved Question

Having Data transfer from Excel intro Word

Jul 25, 2013 3:18AM PDT

I work in a management company and we have about a half a dozen of separate word documents that we have to fill in names,addresses,numbers, etc...

I believe there is a way of automating this but i don't know how or what its called.

I want to be able to type in the information into an excel spreadsheet and have the relevant data transferred to select word documents at certain points in the document. Is this possible?

TIA!

Discussion is locked

Jman787 has chosen the best answer to their question. View answer

Best Answer

- Collapse -
What about Mail Merge in Word?
Aug 1, 2013 5:21AM PDT

You can fill the items in a grid like a spreadsheet. Probably can use your excel file for it too. I have Word97 and use it to address Christmas card envelopes but you could use it to fill in any document.

- Collapse -
Yes, i came across that as well..
Aug 1, 2013 9:33AM PDT

I'll have to look into that...thanks!

- Collapse -
Answer
This sounds like a job for...
Jul 25, 2013 3:20AM PDT

WordPipe.

- Collapse -
And yes this would take a budding programmer
Jul 25, 2013 3:21AM PDT

To tie it all together. It's a company so I'm sure they know how to hire the talent when required.
Bob

- Collapse -
(NT) ok. Thanks!
Jul 31, 2013 1:02AM PDT