mail merge labels

[Ruth]

When creating labels using mail merge, there is one blank
space before the name. All other lines of the address
are properly aligned to the left. I'd appreciate any
ideas. I've merged from Access and from Excel and I get
the same space.

 

[Graham Mayor]

What sort of space? Remove it before propogating the labels prior to running
the merge - see http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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


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

 

[Cindy M -WordMVP-]

Hi Ruth,

When creating labels using mail merge, there is one blank
space before the name. All other lines of the address
are properly aligned to the left. I'd appreciate any
ideas. I've merged from Access and from Excel and I get
the same space.

Are you sure there's not a space in the data, itself?

And no space before the merge field in the main merge
document?

Which version of Word?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[TampaMac]

This problem sounds similar to mine. In your template, do you have prefix, first name, and last name? If you have all three, are you getting data into all three fields? Your template may look like this:
«Prefix» «FirstName» «tLastName» Notice the space between prefix and firstname as well as one between first and last name. If there is no data to fill in prefix the space remains.

My qestion is asking how you can conditionally format the template to remove the space if their is no prefix present in the data. Is this similar to what you are experiencing?

TampaMac

 

[Graham Mayor]

That is easy to arrange with a conditional field which places the mergefield
and its following space only when it has content eg

{IF {Mergefield Prefix} <> "" "{Mergefield Prefix} "}{Mergefield
FirstName}etc
ie
{IF {Mergefield Prefix} <> "" "{Mergefield Prefix}<space here> "}<no space
here>{Mergefield FirstName}etc

Use ALT+F9 to toggle the field display and CTRL+F9 to insert field
boundaries.

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


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

 

[RKW]

I am having the exact same problem. Using Word 2003.

Using Word table data files that have been updated and
working fine for over 10 years, the switch from Word 2000
to Word 2003 has resulted in unusable labels...I have the
space problem mentioned below, random missing address
lines, extra spaces galore, etc. I also have tried
massaging the data to Access & Excel, then back to Word
and have only ended up with the same or similar problems.

I'd hate to have to do a parallel install of Office/Word
2000 just to print labels.