Condition mail merge on 2 fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TonyN - 20 Sep 2006 19:49 GMT

I need to merge a txt file with fileds that include company, firstname, and
lastname (there are other fields in the merge data).

The data souce automatically puts together firstname+lastname into the field
company, for people who don't have a company name entered. I can't change
that.

So, when I merge the data, the name prints out twice for those whose
companyname was a merged firstname+" "+lastname.

I tried something like:
{IF {MERGEFIELD firstname} = {MERGEFIELD company} "----------" {MERGEFIELD
company}

But I think I need to define firstnam+" "+lastname to compare to company.

How do i do this?

Reply to this Message

Doug Robbins - Word MVP - 21 Sep 2006 04:48 GMT

What do you mean by "The data souce automatically puts together
firstname+lastname into the field
company?" You mean that the firstname + lastname is automatically repeated
in those fields in the data source as well as in separate firstname and
lastname fields?

If that is the case, your field construction should be something like

{IF {MERGEFIELD company} <> "{MERGEFIELD firstname} {MERGEFIELD lastname}"
"{MERGEFIELD company } Cr
{ MERGEFIELD nextmergefield }" "{MERGEFIELD nextmergefield}" }

where you insert a carriage return (Press Enter or Shift+Enter) where Cr
appears in the above.

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 need to merge a txt file with fileds that include company, firstname, and
> lastname (there are other fields in the merge data).
[quoted text clipped - 14 lines]
>
> How do i do this?

Reply to this Message

Rate this thread: