Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
conditional merging
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
conditional merging
{ 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
conditional merging
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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
conditional merging
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge from Excel - conditional field choice? | Mailmerge | |||
Conditional Mail Merge Help | Mailmerge | |||
Conditional Slash Similar to Conditional Hyphen? | Page Layout | |||
How do keep blank lines when merging a document with the data and. | Mailmerge | |||
Conditional inclusion of WordArt? | Mailmerge |