"StargateFanFromWork" wrote in message
...
"Peter Jamieson" wrote in message
...
[snip]
Changed it to this format where the Next Record is at beginning
starting with cell #2 onwards. Nothing has changed, though. The labels
are still coming out okay, same as before, and all in the right sequence,
I'm just getting in an extra table row at the bottom of each page of the
merged doct. (there are a total of 4 pages, so 3 of them are 4x21 while
last page is only partially filled as it doesn't fill up an entire page).
[snip]
One clue. Something else weird is happening. In latest test, I tried both
options where we can choose _not_ to print blank lines or not but no matter
which option I choose, I get the same results: about 40 extra filled-in
cells in the last half of the 4th page where just the field "titles" show
up. In other words, the merge is creating a few "blank" cells in the final
merge document. I went back to the Excel data source file and though I knew
I'd defined the print area correctly this morning, went back and set the
print area again. There are absolutely no rows in the data source file that
are completely blank. Yes, there are a couple of blanks in the rows but
nothing to account for 40 empty records showing only titles. Yes, there are
also 2 entire blank columns in the Excel file, but these correspond to
fields that weren't defined in the Word template.
Also, besides having these empty cells, this last page has 4x19 labels
showing vs. the 4x20. Not sure if any of this is significant, but don't
recall seeing either of these 2 things happen before in other merges I've
done. Again, it's been so long I could be wrong, but thought I'd point
these 2 things out.
Cheers and have a good evening. Finishing my day and off to do some grocery
shopping g.
D