Mail Merge Function with 'spouse'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deniz - 21 Nov 2007 12:16 GMT

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

Reply to this Message

Peter Jamieson - 21 Nov 2007 14:30 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 8 lines]
> Thank you.
> Deniz

Reply to this Message

Deniz - 22 Nov 2007 13:17 GMT

Hi Peter,

thank you very much. This works.

Cheers,
Deniz

> The followig should do it as long as person_wifehusbandname is actually a
> zero-length string, not a set of spaces:
[quoted text clipped - 18 lines]
> > Thank you.
> > Deniz

Reply to this Message