How can I? If statement ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buttercup - 23 Nov 2005 18:14 GMT

I have a mail merge that I have set up. Each letter has a closing from a
choice of 5 different people. I would like to include the appropriate e-mail
address with each letter depending on the person in the closing.

I believe I can do some type of IF statement for this, but not sure how to
do this since there are 5 different people.

Hopefully this makes sense.

Thank you,

Jeanmarie

Reply to this Message

Tony Jollans - 23 Nov 2005 18:30 GMT

The simplest is probably to have multiple IF fields, each returning an
e-mail address or nothing ...

{ IF { ClosingName } = Fred fred@exanple.com }{ IF { ClosingName } = Jack
jack@exanple.com }{ etc.

--
Enjoy,
Tony

> I have a mail merge that I have set up. Each letter has a closing from a
> choice of 5 different people. I would like to include the appropriate e-mail
[quoted text clipped - 8 lines]
>
> Jeanmarie

Reply to this Message

Doug Robbins - Word MVP - 23 Nov 2005 18:49 GMT

I would suggest that you have another field in the datasource into which you
insert the email addresses.

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 have a mail merge that I have set up. Each letter has a closing from a
> choice of 5 different people. I would like to include the appropriate
[quoted text clipped - 9 lines]
>
> Jeanmarie

Reply to this Message