How do I lower the position of addresses on a label?

[Frani]

We are trying to print labels for addresses that are in Excel. We do the
setup and the labels look OK on preview, but when they print, they are at the
very top of the label and subsequent labels begin printing at the bottom of
the one above it instead of on a new label. How can we lower these labels?

 

[Graham Mayor]

Start with http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and see
how you get on.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Doug Robbins - Word MVP]

Try printing the labels onto a plain sheet of paper and see how they then
align with the label sheet. There is a common problem with many printers
not being able to accurately feed the label stock that can cause the type of
mis-alignment that you mention.

--
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

 

[pompey]

I have been trying to open Graham Mayer's article, but all the links seem to
be dead. I have tried in both Firefox and IE with the same result.

 

[Doug Robbins - Word MVP on news.microsoft.com]

The link works fine for me. Have you tried printing the labels on plain
paper and comparing the layout with that of the label media? Or is there
some other issue that you have.

--
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, originally posted via msnews.microsoft.com

 

[pompey]

Yes, I have tried that, Doug. The font is too small for that size of label
(postcard size on A4 sheet) and the name and address are huddled up at the
top of the label.
Re Graham Mayer's article, I can click on the link quoted , this takes me to
his web site, but I cannot then open anything on it.

 

[Doug Robbins - Word MVP on news.microsoft.com]

In Word, labels are just tables with fixed cell dimensions, one cell of the
table to a label.

Sounds like you need toright click in the labels and select Cell Alignment
to set the alignment to Centre Left and then set the indent of the paragraph
to move the text to the position that you want on the label

--
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, originally posted via msnews.microsoft.com

 

[Graham Mayor]

While the service provider that hosts my web site occasionally performs
maintenance which may briefly cause access issues, the site is currently
functioning normally. If you cannot access it, I would look first to your
own configuration.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>