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.

{ IF { MERGEFIELD "Print Phone Number" } = "Y" "{ MERGEFIELD "Phone
Number" }"
--
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.
}
"Glenn" wrote in message
...
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.

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.
"Charles Kenyon" wrote in
message ...
{ IF { MERGEFIELD "Print Phone Number" } = "Y" "{ MERGEFIELD "Phone
Number" }"
--
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.
}
"Glenn" wrote in message
...
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.

The braces cannot be typed. You need to use Ctrl-F9 to insert them.
--
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.

"Glenn" wrote in message
...
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.
"Charles Kenyon" wrote in
message ...
{ IF { MERGEFIELD "Print Phone Number" } = "Y" "{ MERGEFIELD "Phone
Number" }"
--
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.
}
"Glenn" wrote in message
...
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.