"Doug Robbins - Word MVP" wrote in message
...
If the mail merge main document is changed to a catalog or directory type
mailmerge document, another row of labels will be added at the bottom of
the sheet. There is however only one table in the document, so the NSEW
points would not appear.
No everything is fine re the type of doct. Helper clearly still states
"Merge type: Mailing Labels".
But I'm just ready to tear my hair out again, all the trials I did yesterday
didn't put a section break in and the second page's table of labels started
on the previous page so that after the 4x20 labels, an extra row would
appear so that it looked like I was getting 4x21 labels per page until the
last page. I added the extra "Section Break (Continuous)" and that fixed it
yesterday.
Now this morning, however, using the same docts., I'm getting a merged doct
that shows a "Section Break (Continuous)" _and_ a "Section Break (Next
Page)". Talk about going round the bend! Word is going to drive me nuts.
At any rate, the 2 codes fit on the bottom of each pg (pg. 2, the last page,
has 2 "continuous" ones rather than one "continuous" and one "next page"
section break code, btw) and no blank pages are generated so I'm just going
to leave the section break code I put into the template as it absolutely did
not work without it yesterday. Even though there are no blank pages coming
out with this test and sometime in future, who knows but that they might get
an extra blank page in between each label sheet, I think that that's an
easier error for the average user to deal with than getting a result that
needs a page break to be put in the exact spot to separate the tables to get
the correct 4x20 labels on each page.
If the mail merge main document is changed to a letter type mailmerge main
document, and the Next Page Section Break that normally separates the
pages, somehow got changed to a Continuous Section break, then another row
of labels will be added to the bottom of the sheet and in this instance,
that row of labels is in a second table in the document so the NSEW points
will appear.
Makes sense except. This didn't happen, though. The same doct. I tried out
again today was a label doct yet without having put in the added section
break, no page break was added yesterday. Yet this morning it did work even
without it. I'm at a loss to figure out why it worked differently today,
but must admit that Word never ceases to play little tricks like this with
me g.
Anyway, I now have a working doct. that my guys can use for adding info to
each unit they're repairing so that's what counts.
Thanks. Really appreciate all the help.
D
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Peter Jamieson" wrote in message
...
Another thing to check - if you bring up the Mail Merge Helper, does it
still say you are doing a label merge? If it had somehow changed to being
a Catalog merge, then it probably wouldn't do a page break after it had
merged each page. If there was space for a complete table row at the
bottom of the page, it would probably be added to the existing table.
Adding a section break might change that behaviour. However, that's a bit
far-fetched.
In any case, I don't really see how MailMerge can be cramming 21 rows
onto one page if they are the correct height to match your label
stationery, which suggests that there's still something wrong in the
layout department.
Peter Jamieson
"StargateFanFromWork" wrote in message
...
"StargateFanFromWork" wrote in message
. ..
"Peter Jamieson" wrote in message
...
[snip]
wait a minute ... just noticed something ... I'll be danged. The last
table row at the bottom of the first page is actually the first table
row of a second table that should actually start on page 2. I had not
seen the square with the NSEW points before signalling the start of a
table because the mouse pointer must be in a certain spot over a table,
as we all know, and I hadn't mouse over any area in the table that
would show this before until now. I just inserted a page break between
the two "tables" and everything was fine.
So, what does this mean? Am I missing a break of some sort at the
bottom of my original Word template? Could it be something as simple
as that??
[snip]
I played around with this and ended up inserting a section break right
underneath the end of the table on the page of my original Word
template. That seemed to do the trick. Is this acceptable Word usage
for this type of thing? I'm asking because sometimes what we stumble
upon doing is the best way to do something and it might cause problems
down the road in other situations. Again, this seemed to do the trick.
I'll test tomorrow by adding pages of dummy info to the Excel file to
get several sheets in the merge and I'll see what happens then.
Thanks. D