Compound IF in merge field

I have been merging Excel to Word2K without a problem. Now what I
want to do is the following:

If PropertyVacant = 1 then "Vacant"
elseif PropertyRented = 1 then "Rented"
else
"Owner Occupied"
endif

The fields PropertyVacant and PeopertyRented are on the merged Excel
file. I want to put the literals on the Word document.

I know I can use VBA but I'm not sure exactly how and were to put it
in VBA.

Any help would be appreciated.

Jim,

You can do this with fields in the merge document without
using VBA:

{IF{MergeField PropertyVacant} = "1""Vacant"{IF{MergeField
PropertyRented} = "1""Rented""Owner Occupied"}}


-----Original Message-----
I have been merging Excel to Word2K without a problem.
Now what I
want to do is the following:

If PropertyVacant = 1 then "Vacant"
elseif PropertyRented = 1 then "Rented"
else
"Owner Occupied"
endif

The fields PropertyVacant and PeopertyRented are on the
merged Excel
file. I want to put the literals on the Word document.

I know I can use VBA but I'm not sure exactly how and
were to put it
in VBA.

Any help would be appreciated.
.