[Chris Hughes]

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.

[Graham Mayor]

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.

[Chris Hughes]

Thanks for that, Graham. Sorry, but I don't know coding. Tried copying and
pasting your code - didn't work!

[Graham Mayor]

You cannot copy fields from plain text to Word. You must build the field in
Word using CTRL+F9 for each bracket pair and use the exact field name(s)
from your data source.
See also http://www.gmayor.com/formatting_word_fields.htm
--

Graham Mayor - Word MVP

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



Chris Hughes wrote:
Thanks for that, Graham. Sorry, but I don't know coding. Tried
copying and pasting your code - didn't work!