Export rows in Excel to lutiple Word files
 

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.......

Export rows in Excel to lutiple Word files
 

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.








" wrote:

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.......

Export rows in Excel to lutiple Word files
 

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

Export rows in Excel to lutiple Word files
 

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.