conditional merging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 14 Dec 2005 17:32 GMT

I am trying to create a directory.

The directory will contain everyone's name and address.

It will contain their phone number only if they have given permission to me
to include it.

So, I have an access database that contains all the information.

I have a phone number for everyone.

I have a field entitled "Print Phone Number"

What I want to do is something like If Print Phone Number = "Y" then show
the number from the "PhoneNumber" field, but I can't seem to get it to work.

Any help would be appreciated.

Thanks.

Reply to this Message

Charles Kenyon - 14 Dec 2005 17:37 GMT

{ IF { MERGEFIELD "Print Phone Number" } = "Y" "{ MERGEFIELD "Phone
Number" }"

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
}

>I am trying to create a directory.
>
[quoted text clipped - 17 lines]
>
> Thanks.

Reply to this Message

Glenn - 14 Dec 2005 18:49 GMT

I tried to copy this and paste it (after press Alt F9 to display the codes),
but it shows up as text, not as a merge code.

> { IF { MERGEFIELD "Print Phone Number" } = "Y" "{ MERGEFIELD "Phone
> Number" }"
[quoted text clipped - 19 lines]
> >
> > Thanks.

Reply to this Message

Charles Kenyon - 14 Dec 2005 20:26 GMT

The braces cannot be typed. You need to use Ctrl-F9 to insert them.

Signature

>I tried to copy this and paste it (after press Alt F9 to display the
>codes),
[quoted text clipped - 24 lines]
>> >
>> > Thanks.

Reply to this Message