Export rows in Excel to lutiple Word files

[nodiseos]

I have an excel (or access if easier) doc that contains rows of data.
I would like to create a separate word doc from each row.

The clomuns are subject,number,info

I would love the title of each to be "<Number>-<Subject>" with the
content of the doc itself made up from the Info row.

Is there a way to do this - I know a bit of perl but was hoping for an
easy solution.......

 

[Guest]

Try this.

Select the row
Copy to the clip board
Switch to MS Word
Use either Paste to paste the clipboard contents as a table or Paste Special
with the Link Option selected. Perhaps specify as an Excel Worksheet Object.

With many rows this could get tedious but I will get you what you want.

 

[nodiseos]

Uh, I was hoping for something a wee bit automated.

 

[Jay]

I have an excel (or access if easier) doc that contains rows of data.

I would like to create a separate word doc from each row. ...

One approach is Word's "Mail Merge" feature.