Mailmerge lables - rogue space when there's no title (Mr, ..

Most of my contacts don't have titles (Mr, Mrs, etc).
In the Create Labels box, in the first line, I insert merge fields as so:
title, [space], firstName, [space], surName.
The problem then is that when there's no title, the first line begins with a
space. I tried adding a space after the title in the data source (Excell),
but the mailmerge ignores it.
I'm using Office 2000.

Conditionally insert the title and the trailing space e.g.

{ IF{ Mergefield Title} <> "" "{ Mergefield Title } " }{ Mergefield Name }

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

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


Chris Hughes wrote:
> Most of my contacts don't have titles (Mr, Mrs, etc).
> In the Create Labels box, in the first line, I insert merge fields as
> so: title, [space], firstName, [space], surName.
> The problem then is that when there's no title, the first line begins
> with a space. I tried adding a space after the title in the data
> source (Excell), but the mailmerge ignores it.
> I'm using Office 2000.