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
Doug Robbins - 23 Aug 2005 13:04 GMT
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.

Signature
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
>I am trying to set up a mail merge in Word 2000 using data from an Excel
>2000
[quoted text clipped - 23 lines]
>
> Kim