Word 97 Labels templates dispay records in bottom margin

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy - 09 Sep 2005 18:18 GMT

I've been experimenting with several different options from the Avery
product list and it seems that if there are more than enough records
selected (to fill the sheet of labels) the next records are displayed
in the bottom margin. Is there a cure for this?

Reply to this Message

Anne Troy - 09 Sep 2005 20:22 GMT

If you're doing a mail merge, you've got some merge codes in the wrong
place....
************
Anne Troy
www.OfficeArticles.com

> I've been experimenting with several different options from the Avery
> product list and it seems that if there are more than enough records
> selected (to fill the sheet of labels) the next records are displayed
> in the bottom margin. Is there a cure for this?

Reply to this Message

Judy - 09 Sep 2005 21:51 GMT

I should have been more clear in discribing the problem. The templates
look fine with all the field names inserted in all the right places but
after the mail merge the NEW document created continues to display
fields even in the bottom margin. I've tried starting New Templates
from the begining both for address labels and business cards and they
look fine up in the preview until the bottom margin where the next
records try to display as many lines as possible running of the bottom
of the page even though there are NO fields inserted there.

Any ideas how correct this?

Reply to this Message

Anne Troy - 10 Sep 2005 19:39 GMT

I would begin by troubleshooting Word, Judy. If that doesn't help, see what
the doc looks like on another PC. If you don't have one, join
www.officearticles.com/forum and upload a sample file there for me to look
at. See Word troubleshooting here:
http://www.officearticles.com/word/steps_to_troubleshooting_microsoft_word.htm
************
Anne Troy
www.OfficeArticles.com

>I should have been more clear in discribing the problem. The templates
> look fine with all the field names inserted in all the right places but
[quoted text clipped - 6 lines]
>
> Any ideas how correct this?

Reply to this Message

Judy - 12 Sep 2005 00:20 GMT

Hi Anne,
Thanks so much for the link. It looks like a great resource! I've
discovered that I can pull up the files created in Word97 using Word
2000 and although those same files show records stuffed into the
margins in Word97, they look perfect in Word 2000. (Of course I have
to save the .dat (data source) as a .txt file first.) Anyway, I've
registered at officarticles.com and I've posted both a sample 97 file
and a small .dat file to use for testing. I sure hope someone can
find a solution to this mystery. I did some more searching in this
group and found mention of an schema.ini file but I searched both my
system with Word 97 and another system with Word 2000 and neither
system seemed to have the file in question. I'm running out of ideas.

Reply to this Message

Graham Mayor - 11 Sep 2005 06:08 GMT

Labels are merely tables and your fields should be in the table cells. The
only way I can see that a merge could attempt to add more cells than there
is space for on the page would be if there is a disparity between the page
size between the printer settings and the page settings. There should be no
way for a merge to move fields outside the cells into the bottom 'margin'.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I should have been more clear in discribing the problem. The
> templates look fine with all the field names inserted in all the
[quoted text clipped - 7 lines]
>
> Any ideas how correct this?

Reply to this Message

Judy - 11 Sep 2005 21:46 GMT

I agree that it's very strange. That is why I tried different Avery
product selections as well as from different computers with Word 97,
inserting fields only within the "sample label". I made no changes to
margins. Since my last post, I've discovered that I can pull up one of
these same templates (created on Word 97) using Word 2000 and as long
as I change the datasource from the .dat file to a .txt version of the
file, it displays perfectly. If I don't change the datasource I get
the same error about "Word could not parse your query into valid SQL
string" that I got trying to use a txt file datasource with 97. I
wonder if the problem with the 97 display has something to do with the
.dat datasource.

Reply to this Message

Judy - 14 Sep 2005 19:01 GMT

In case someone should one day be searching for the solution to this
problem, the mystery has been solved. There is a problem with the
"Print View" in Word 97 when used with the label merge. Ignore what
you see in "Print View" and print them anyway.

Reply to this Message