If ...elseif ...elseif ....then statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zSplash - 10 Mar 2005 20:18 GMT

How do I code multi-else's using mail merge? Example: I want whatever is
City to be Ucase, but evidently I can't use VBA code in mail merges, so I
can figure out how to make Seattle capitalized if City = Seattle, but how do
I add other cities? I have tried, but only get City instead of TUCSON:

{IF {MERGEFIELD City}= Seattle "SEATTLE" {IF{MERGEFIELD City} = Tucson
"TUCSON"} ""}

If City <> one of my "defined" cities, can I just merge, and let the field
stop and let the user manually type in (capitalized) City?

I hope my question is clear. TIA.

Reply to this Message

Greg Maxey - 10 Mar 2005 20:49 GMT

You want the City in CAPs correct?

Try {Mergefield City \* UPPER }

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> How do I code multi-else's using mail merge? Example: I want
> whatever is City to be Ucase, but evidently I can't use VBA code in
[quoted text clipped - 9 lines]
>
> I hope my question is clear. TIA.

Reply to this Message

zSplash - 10 Mar 2005 20:58 GMT

Thanks so much.

st.

> You want the City in CAPs correct?
>
[quoted text clipped - 13 lines]
> >
> > I hope my question is clear. TIA.

Reply to this Message

zSplash - 10 Mar 2005 21:28 GMT

But, can I have multi-elses? I tried, and got error: Unknown op code for
conditional:

{IF{MERGEFIELD Office}=1 "Seattle" {IF{MERGEFIELD Office}=2 "Portland"
{IF{MERGEFIELD Office}=3 "Fresno" {IF{MERGEFIELD Office}=4 "Tucson"}

I see that there are more left wavy brackets than right ones, and that I
haven't concluded the equation (what if not 1, 2, 3, or 4), but I don't
understand. Could someone help or direct me to a good rudimentary
explanation? TIA

> You want the City in CAPs correct?
>
[quoted text clipped - 13 lines]
> >
> > I hope my question is clear. TIA.

Reply to this Message

Greg Maxey - 10 Mar 2005 21:48 GMT

Yes you can have multiple IF conditions.

{ IF { Test }="1""SEATLLE"{ IF{ Test }="2""PORTLAND"{ IF {
Test }="3""FRESNO"}}}

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> But, can I have multi-elses? I tried, and got error: Unknown op code
> for conditional:
[quoted text clipped - 28 lines]
>>>
>>> I hope my question is clear. TIA.

Reply to this Message

Greg Maxey - 10 Mar 2005 21:55 GMT

zSpash,

Sorry for the clipped reply earlier. My wife was assigning me a chore :-)

You can nest the additional conditions as I showed you in my last post
(replace Test with your mergefield name) or in this case you can simply gang
them together
{IF{TEST}="1""SEATTLE"}{IF{TEST}="2""PORTLAND"} etc.

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> But, can I have multi-elses? I tried, and got error: Unknown op code
> for conditional:
[quoted text clipped - 28 lines]
>>>
>>> I hope my question is clear. TIA.

Reply to this Message

zSplash - 10 Mar 2005 22:30 GMT

Thanks, Greg. Your earlier example was fine.

So, now I wonder, can I compare 3 fields from the data source and based on
the comparison, "get" one of the fields? (That is, consider 3 unique
fields: num3, num2, num1. If num3 is empty, check num2; if num2 is empty,
"get" num1.) Do I use "IF THEN" or something else?

It's just a little sad trying to "get the syntax (i.e., the demanded # of
curly braces, etc.)" for the mail merge Word fields when things are so
straight-forward in VBA.

TIA

> zSpash,
>
[quoted text clipped - 37 lines]
> >>>
> >>> I hope my question is clear. TIA.

Reply to this Message

Greg Maxey - 10 Mar 2005 22:53 GMT

zSplash,

Not tested, but try something like:

{ IF { NUM1 }<>""{ NUM1 }{ IF{ NUM2 }<>""{ NUM2 }{ NUM3}}}

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> Thanks, Greg. Your earlier example was fine.
>
[quoted text clipped - 57 lines]
>>>>>
>>>>> I hope my question is clear. TIA.

Reply to this Message

zSplash - 11 Mar 2005 00:31 GMT

Thank you so much, Greg. Your help has been outstanding (and worked)!

st.

> zSplash,
>
[quoted text clipped - 63 lines]
> >>>>>
> >>>>> I hope my question is clear. TIA.

Reply to this Message

Peter Jamieson - 11 Mar 2005 01:04 GMT

You can use VBA in merges if you are using Word 2002/2003 by using the
Mailmerge events, which give you the opportunity to modify the mail merge
main document before each record is merged, and so on. For example, suppose
your Mail merge Main document has adocvariable field called

{ DOCVARIABLE myvalue }

then you can do all your if..then..else stuff in VBA in the appropriate
event handler and simply set the document variable "myvalue" to the result
you want.

Peter Jamieson

> How do I code multi-else's using mail merge? Example: I want whatever is
> City to be Ucase, but evidently I can't use VBA code in mail merges, so I
[quoted text clipped - 10 lines]
>
> I hope my question is clear. TIA.

Reply to this Message