Mail Merge Function with 'spouse'

[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.

 

[Deniz]

Hi Peter,

thank you very much. This works.

Cheers,
Deniz