close

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 quot;lt;Numbergt;-lt;Subjectgt;quot; 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.quot; wrote:

gt; I have an excel (or access if easier) doc that contains rows of data.
gt; I would like to create a separate word doc from each row.
gt;
gt; The clomuns are subject,number,info
gt;
gt; I would love the title of each to be quot;lt;Numbergt;-lt;Subjectgt;quot; with the
gt; content of the doc itself made up from the Info row.
gt;
gt; Is there a way to do this - I know a bit of perl but was hoping for an
gt; easy solution.......
gt;
gt;

Uh, I was hoping for something a wee bit automated.gt; I have an excel (or access if easier) doc that contains rows of data.
gt; I would like to create a separate word doc from each row. ...

One approach is Word's quot;Mail Mergequot; feature.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()