conditional merge fields

[Linea Recta]

I have designed a (C6) envelope in MSWord containing merge fields from my
Access database.
I'm nearly getting what I want, but...
the last field is the country field. How can I achieve that this field is
NOT displayed, when it contains my own country?


--
regards,

|\ /|
| \/ |@rk
\../
\/os

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Mark,

The field construction would be like

{ IF { MERGEFIELD "Country" } < > "Your Country" { MERGFIELD "Country" }
"" }

You must use Ctrl+F9 to insert each pair of { } and Alt+F9 to hide the field
construction.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Linea,

Which VERSION of Word do you have?

the answer that's valid for all versions is to create an IF field. Use the
"Insert Word field", If...Then...Else dialog box to set it up. Since this
won't let you insert a merge field as a True or False result, type in a
placeholder text.

Once you've OK'd the dialog box, press Alt+F9 to display the field codes.
Select the placeholder text and insert the merge field in its place. Alt+F9
again to hide the field codes.

I have designed a (C6) envelope in MSWord containing merge fields from my
Access database.
I'm nearly getting what I want, but...
the last field is the country field. How can I achieve that this field is
NOT displayed, when it contains my own country?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Linea Recta]

Right, seems to work fine here!

thanks,


|\ /|
| \/ |@rk
\../
\/os




"Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS"

 

[Linea Recta]

I have Office XP. (Word 2002?) I tried your solution too for curiosity. It
also seems to work fine.


thanks,

|\ /|
| \/ |@rk
\../
\/os

 

[Linea Recta]

"Cindy M -WordMVP-" <[email protected]> schreef in bericht
--- cut ---

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)

Hi Cindy,

Nice site ^. I can actually enlarge the font size! On most internet sites
this option seems disabled nowadays and so they are barely readable by hires
users...


--
regards,

|\ /|
| \/ |@rk
\../
\/os

 

[Cindy M -WordMVP-]

Hi Linea,

I have Office XP. (Word 2002?)

In this version, you also can try using the AddressBlock. It's pretty good for
US addresses, but can be a problem for other countries, you'd have to try it.
It does have an option for suppressing a particular country, in any case.

Nice site ^. I can actually enlarge the font size! On most internet sites
this option seems disabled nowadays and so they are barely readable by hires
users...

Thanks When I set it up, I tried to use techniques that would make it
accessible to a wide range of users and browsers. The "itch" is always there
to make it "slicker", but so far I've been so busy I've been able to resist...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail