[Deniz]

Hi,

I need your help. I have to print labels with MS Word and ne a formula to
select the correct data and fill into my template.
I would like word to understand following:
'IF there is a wife/husband name in the record then fill in 'personname &
person_wifehusbandname' otherwise simply fill in the personname.'

How can I do this formula as a merge field?

Thank you.
Deniz

[Peter Jamieson]

The followig should do it as long as person_wifehusbandname is actually a
zero-length string, not a set of spaces:

{ MERGEFIELD personname }{ IF "{ MERGEFIELD person_wifehusbandname }" = ""
"" " & { MERGEFIELD person_wifehusbandname }" }

All the pairs of {} need to be the special field code braces that you can
insert using ctrl-F9. Everything is ordinary text that you can type on the
keyboard. The whole thing can be on a single line.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Deniz" wrote in message
...
Hi,

I need your help. I have to print labels with MS Word and ne a formula to
select the correct data and fill into my template.
I would like word to understand following:
'IF there is a wife/husband name in the record then fill in 'personname &
person_wifehusbandname' otherwise simply fill in the personname.'

How can I do this formula as a merge field?

Thank you.
Deniz

[Deniz]

Hi Peter,

thank you very much. This works.

Cheers,
Deniz

"Peter Jamieson" wrote:

The followig should do it as long as person_wifehusbandname is actually a
zero-length string, not a set of spaces:

{ MERGEFIELD personname }{ IF "{ MERGEFIELD person_wifehusbandname }" = ""
"" " & { MERGEFIELD person_wifehusbandname }" }

All the pairs of {} need to be the special field code braces that you can
insert using ctrl-F9. Everything is ordinary text that you can type on the
keyboard. The whole thing can be on a single line.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Deniz" wrote in message
...
Hi,

I need your help. I have to print labels with MS Word and ne a formula to
select the correct data and fill into my template.
I would like word to understand following:
'IF there is a wife/husband name in the record then fill in 'personname &
person_wifehusbandname' otherwise simply fill in the personname.'

How can I do this formula as a merge field?

Thank you.
Deniz