T
Tad
I'm trying to merge data from just the 2nd row of an Excel spreadsheet
into a Word document. The merge fields are already in the Word document
and in the first row of the Excel spreadsheet. Using the Data Manager I
select the spreadsheet through Data Source - Get Data options at which
point the Open Workbook window pops up. On the top line I select the
workbook tab cooresponding to the borkbook that the data is on, but
when I merge to new document the result is multiple copies of the
document because the program pulls the data from rows 3 to 6 in
addition to row 2. So I tried to select the cell range in the open
workbook window, but the OK button grays out as soon as I enter any
text or numeral in the cell range section. Any suggestions? Thanks.
into a Word document. The merge fields are already in the Word document
and in the first row of the Excel spreadsheet. Using the Data Manager I
select the spreadsheet through Data Source - Get Data options at which
point the Open Workbook window pops up. On the top line I select the
workbook tab cooresponding to the borkbook that the data is on, but
when I merge to new document the result is multiple copies of the
document because the program pulls the data from rows 3 to 6 in
addition to row 2. So I tried to select the cell range in the open
workbook window, but the OK button grays out as soon as I enter any
text or numeral in the cell range section. Any suggestions? Thanks.