I am trying to set up a mail merge in Word 2000 using data from an Excel 2000
file.

The data is a list of contact names and addresses. I want to do this mail
merge so I can print off address labels for these contacts.

Some of the contacts have titles (Dr, Mr, Ms, etc), however, some do not.
With contacts that have titles, I want the label to have a space between the
title and the first name. With contacts that do not have titles, I want the
names to appear at the start of the first line of the label, without a space.

How can I do this?

I have tried inserting a space after each title in the excel file; however,
Word seems to ignore these spaces.

When I enter the form fields as title name, this creates an ugly
space at the start of the lines for labels where there is no title.

Any advice gratefully received!

Kim

Use the following If...then...Else field construction

{ IF { MERGEFIELD Title }= "" "{ MERGEFIELD Name }" "{ MERGEFIELD Title }
{ MERGEFIELD Name }" }

You must use Ctrl+F9 to insert each pair of field delimiters { }, and Alt+F9
to toggle off their display.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Groovykimu" wrote in message
...
I am trying to set up a mail merge in Word 2000 using data from an Excel
2000
file.

The data is a list of contact names and addresses. I want to do this mail
merge so I can print off address labels for these contacts.

Some of the contacts have titles (Dr, Mr, Ms, etc), however, some do not.
With contacts that have titles, I want the label to have a space between
the
title and the first name. With contacts that do not have titles, I want
the
names to appear at the start of the first line of the label, without a
space.

How can I do this?

I have tried inserting a space after each title in the excel file;
however,
Word seems to ignore these spaces.

When I enter the form fields as title name, this creates an ugly
space at the start of the lines for labels where there is no title.

Any advice gratefully received!

Kim