I need dynamic data fed from excel to a word file. How do I do that, whats the easiest solution?

Question

If I change data (numbers) in the excel sheet it chnages also in a word file...

Answer 1

You definitely want to learn Mail Merge in word. Contrary to the way microsoft promotes it, it's NOT usually just for "letters and mailings".



It's for any document you can think of that you want to open the word document, and let's say you want to print a boilerplate letter or document in Word, with one or more fields (as many fields as you want) that have variable values. And they can come from an excel spreadsheet, or from an Access database query / table. And a lot of other sources, but it sounds liek you will just browse for your excel sheet.



In Word 2007, they made it (like most other changes in 2007), extra deceptive and hard to get to. Instead of "mail merge", they call it "Letters and Mailings".



Use the wizard, it's super easy and awesome. Find it under the Mailings tab, and then do Step by Step Wizard.



Ever time you open your new Mail Merge word doc, it will update the thing automatically, and when you "Merge to Printer", then it will print all (however many records there are ).

Answer 2

Use the mail merge feature of word and use the excel sheet as the source database.



alternatively you would need to insert a Direct Data Exchange (DDE) object so that word knows the data is dynamic in nature and checks for changes.



Hope this helps.

Answer 3

a million> deploy Adobe Arobat (not reader, in uncomplicated words Acrobat is a paid software) 2> Open a MS note document from it. in this kind you are able to convert a Microsoft note document into an Adobe PDF document.