Word file with "database fields" to reduce workload.

[mephisto102]

Dear all,

I have the following situation. I have a word-file with 41 pages. Now through the documents I have to change certain data like company names, employee names and also some tables which contain "X" to mark some choosen options.

Of course I can change this manually over and over again.
It would be much simpler if I could do this more or less automatically like mail merge.

Would it be possible to create an Excel with more than one tabs, that contain the choosen information by the customer. And link this to a Word file.

Lets say I create one Excel file with the following tabs:
- Employees
- Company data such as: manager name, name of coordinator and a couple more
- Three or more tabs with: Tables with information regarding education like effective hours, learning goals etc.

Then I would like to have this excel file linked to a Word-file.
By linking this Excel it would replace the dynamic fields in the Word file with the data from the Excel file. This would include also the tables styled in Excel.

An example of the Excel is with this post.



If anybody know how to do this please let me know. If there would be another way let me know as well. This way every employee can have his own personalized study manual.

Kind regards and many thanks in advance.

[macropod]

You could simply copy a given range from Excel, then paste it into Word using Paste Special with the 'paste link' option and the data format of your choice. Then, whenever the Excel data change, the Word document will auto-update.

[mephisto102]

Thank you MacroPod,

I've managed to merge de data based upon the merge data. And the tables are embedded via de copy and past link. This now seems to work fine.