Export rows in Excel to lutiple Word files

N

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

Peter Ellis

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

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. ...
Click to expand...

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