extra space in labels

[Terri L. Jones]

Each time I do a mailmerge for labels, I get a space at the beginning of each label. I've tried moving and removing the <<Next Record>> to no avail. How do I remove that extra space? I'm using Word 2003.

Thanks

 

[Peter Jamieson]

You are likely to see this problem if you are inserting your data using
fields which are not completely blank (e.g. have a single space in them), or
if you are using an ADDRESSBLOCK field and, for example, you have a last
name but no title or first name (see my nearby message in response to Dee's
message, which describes a similar problemexcept that in your case you
probably need to look at what is in the first line of the ADDRESSBLOCK).

It's difficult to prescribe a solution without knowing the exact cause - if
there are spaces in your data, try to remove them. If it's an ADDRESSBLOCK
problem, you probably need to use individual fields instead, nested inside
IF fields. That's a bit more complicated so let's be sure that the problem
is ADDRESSBLOCK first - if not, let us know.

 

[Gil]

The problem is that the Label Wizard uses a default which
formats the first line of the label with "Mr.". This
seems OK because you expect that it is just part of the
name field string. But, if you exported your mailing list
from a program such as your Address Book, you may have
exported just the name field as a single data entry. The
wizard should ignore the blank "Mr." field but it doesn't
seem to do so. SOLUTION: Pick a format that does not
include "Mr." and (because the same thing can happen with
the "First_Name" field being blank)use the Assign Fields
button to assign the name field in your incoming database
list to First_Name.