Mail Merge - If statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nieve - 02 Aug 2006 12:25 GMT

Hi

I have a mail merge letter to send to potential clients.

Some of the data in one merge field (<<Contact Name>>) is 'No Contact'. I
want to set a rule in the mail merge template that says when the data 'No
Contact' is merged it is replaced with 'The Manager'. Is there a way of doing
this?

(I know I could do Find and Replace ('No Contact' with 'The Manager') in
excel (where the data is stored), or when the mail merge is completed. This
is not a solution however, as I simply need the template to do it for me).

Thanks

Nieve

Reply to this Message

Dave Shaw - 02 Aug 2006 12:57 GMT

I would suggest that you insert a field code such as:

{ IF {MERGEFIELD Contact Name} = "No Contact" "The Manager" "{MERGEFIELD
Contact Name}"}

To do the above ensure you can see field codes - Tools, Options, view, field
codes, and insert the {} using Ctrl + F9

Hope this helps

Dave

> Hi
>
[quoted text clipped - 12 lines]
>
> Nieve

Reply to this Message

Nieve - 02 Aug 2006 14:36 GMT

Hi Dave

Thanks a mil.

That worked great!

Nieve

> I would suggest that you insert a field code such as:
>
[quoted text clipped - 24 lines]
> >
> > Nieve

Reply to this Message

Nieve - 02 Aug 2006 14:41 GMT

Hi.

I actually had to fiddle around with the code.

The correct code is

{ IF {MERGEFIELD Contact Name} = "No Contact" "The Manager" "{MERGEFIELD
“Contact Name”}
"}

It worked great anyhow!

Nieve

> I would suggest that you insert a field code such as:
>
[quoted text clipped - 24 lines]
> >
> > Nieve

Reply to this Message

Dave Shaw - 02 Aug 2006 16:48 GMT

The mergefields that you are doing the conditional argument on and the
result would normally be the same. By putting in a line break at the end of
the 'else' part will result in an additional line break if this condition is
met.

Anyway glad to be of help

> Hi.
>
[quoted text clipped - 38 lines]
> > >
> > > Nieve

Reply to this Message

Rate this thread: