Rows of Text on a Label

D

D Small

Office 2000. My data source is from a Word table. I have no extra columns; just
the ones which hold the data I am actually using in the labels.

My label paper is Avery Standard 5260. My font style and size is Arial 10 in
both the data document and in the main document (I know the font style and size
on the labels are determined by those attributes in the main document).

When I merge the material, Word (starting in the middle horizontal row of each
label) arranges the text too close to the top of each label, as well as creating
two empty rows below my last rows of text.

In other words, when I have three or four rows of text merged, Word adds space
for two more rows. In order for the labels to look professional, I have to go
to the main document and individually delete out the two empty rows of space
created by Word, so the rows look like they are space properly, vertically.

Is there a fix for this? I don't see any adjustments in the label detail
procedure to say how many rows I will be printing.
 
G

Graham Mayor

Display the hidden formatting (CTRL+*)
Check the merge document for extra paragraph marks.
Format the table as centre aligned.
Merge to a new document.

A wildcard replace of
^13{2,}
with nothing
would remove extra paragraph marks from the target document if required.

Though aimed primarily at Office XP - you might find
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm useful

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
D

D Small

Thank you, Graham. At least I know the resulting errors are not my fault. I have
heavily used Word's flat databasing features (in tables) since the early 1980's
and never had a problem until Word 2000.

The first thing I noticed was that Word, apparently by default, decides that the
new table full of information (the data document) is already the main document
(the one with brackets) which, of course, isn't. Only until I found the button
to turn it into a regular Word document was I able to go ahead with the Mail
Merge Helper functions.

PS: re: from your instructions below: In Word 2000, neither the main document
nor the data document respond to CTRL* (to display hidden formatting) (unless I
have something turned off). However for others who notice this, clicking on the
paragraph mark on the standard toolbar will do the same thing. I did not read
anything in the help files that indicated we would automatically get six rows
per label, nor how to get rid of the extra ones.

Thanks for revealing the differences of the mail merge helper over the years.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top