Export rows in Excel to lutiple Word files

  • Thread starter Thread starter nodiseos
  • Start date Start date
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.......
 
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.
 
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.
 
Back
Top