Link Word Document to Excel sheet and automate

[ab2026]

I would like to automate a information pull from Excel into certain areas a Word Document. The spreadsheet has a standard number of criteria and likewise the Word document has a standard set of data points that I need to populate. I would like to automate the link between the two. Would really appreciate advise on how to achieve this. Thanks.

 

[charles352]

If you figured out how to do this please let me know. Here's what I figured out but I'm having problems.

Using Office 2003
Go to your data in Excel and Copy it, if its a cell or a range, doesn't matter.

Go into your Word document and Paste, then use the formatting box that comes up next to your paste and select if you want to keep the text or LINK it.

If I link it, there's the text and I can use the source formatting or the Word formatting.

But there is a line break that shouldn't be there

Example, after 4.5% the line is forced to wrap... WHY ?

The vacancy rate in the western united states was 4.5%
while in California it was only 2.5%