[Noel]

I have a mail merge letter that pulls information from an access database. I
need to put in an IF statement that says if the type of purchase is buy back,
then it is to mail merge the amount in the Buy Back merge field, if it's a
Buy In, then it needs to merge it into the Buy In merge field. The amounts
pull from the same field in access.

Thanks

"Dave Shaw" wrote:


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


"Nieve" wrote:

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






"Dave Shaw" wrote:

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

"Nieve" wrote:

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