Need multiple Ifs in Merge Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Cortez - 22 Nov 2004 22:07 GMT

During the merge, I would like to test (1) if a field is "Business" then type
in Company name If it is not blank. I'm using the If..Then..Else to do this.
Can someone supply the syntax for this using multiple IFs? Thanks!

Reply to this Message

Doug Robbins - 22 Nov 2004 23:57 GMT

If the company name is going to change for each record, it would be far
better to add a field to the data source to contain the name.

{ IF { MERGEFIELD "yourmergefieldthatmaycontainBusiness" } = "Business" {
MERGEFIELD "CompanyName" } "" }

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> During the merge, I would like to test (1) if a field is "Business" then
> type
> in Company name If it is not blank. I'm using the If..Then..Else to do
> this.
> Can someone supply the syntax for this using multiple IFs? Thanks!

Reply to this Message

Pat Cortez - 23 Nov 2004 18:51 GMT

Doug, thanks for your reply but I've tried this before and it isn't enough.
Let me try to explain a little more. Sometimes the mailing address is a home
address, not always a business address. What is happening is that the home
address shows up with a company name, not good. So that is why I need to
test first to see if the mailing address is a business address and then if it
is, to add the Company name, otherwise don't. I believe what I need is the
syntax for a nested IF. Hope you've got a solution. Thanks in advance. Pat

> If the company name is going to change for each record, it would be far
> better to add a field to the data source to contain the name.
[quoted text clipped - 7 lines]
> > this.
> > Can someone supply the syntax for this using multiple IFs? Thanks!

Reply to this Message

Doug Robbins - 23 Nov 2004 23:31 GMT

Who is determining what sort of address it is, you or the computer? What
does the "test" amount to?

Signature

> Doug, thanks for your reply but I've tried this before and it isn't
> enough.
[quoted text clipped - 22 lines]
>> > this.
>> > Can someone supply the syntax for this using multiple IFs? Thanks!

Reply to this Message

Pat Cortez - 29 Nov 2004 21:09 GMT

Hi Doug. Thanks for your continued help. There is a field holding either
the word "Business" or "Home". This determines whether to go onto the next
decision whether to print the Company name or not. Hope this helps to
understand the question. What I'm after is the syntax for a multiple IF
statement I could use during a merge. Thanks again.

> Who is determining what sort of address it is, you or the computer? What
> does the "test" amount to?
[quoted text clipped - 25 lines]
> >> > this.
> >> > Can someone supply the syntax for this using multiple IFs? Thanks!

Reply to this Message

Doug Robbins - 30 Nov 2004 01:11 GMT

The field will look something like:

{ IF { MERGEFIELD "Thefieldthatwillcontaineitherbusinessorhome" } =
"Business" { MERGEFIELD "Companynamemergefield" } "" }

Signature

> Hi Doug. Thanks for your continued help. There is a field holding either
> the word "Business" or "Home". This determines whether to go onto the
[quoted text clipped - 39 lines]
>> >> > this.
>> >> > Can someone supply the syntax for this using multiple IFs? Thanks!

Reply to this Message