If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If Then Help Please
I’ve looked around here but couldn’t find the solution. I’m missing something.
This is what I would like to accomplish; IF { MERGEFIELD Address1 } = “text I want” then insert { MERGEFIELD Unit }, If not as in something different, do nothing. I’m using Word and Excel 2003 Thanks |
#2
|
|||
|
|||
If Then Help Please
Using Ctrl+F9 to insert each pair of field delimiters
{ IF { MERGEFIELD Address1 } = "text I want" { MERGEFIELD Unit } "" } The "" is not really necessary. Use Alt+F9 to toggle off the display of field codes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "BotR" wrote in message ... I’ve looked around here but couldn’t find the solution. I’m missing something. This is what I would like to accomplish; IF { MERGEFIELD Address1 } = “text I want” then insert { MERGEFIELD Unit }, If not as in something different, do nothing. I’m using Word and Excel 2003 Thanks |
#3
|
|||
|
|||
If Then Help Please
Thanks Doug,
Odd, that's what I had and it didn't work. So I rebooted, tried a test with new Data and word doc, and it worked. Then I tried it again in the real doc and it worked. But now my {ADVAVCE \y 240} doesn't work. It is lower down at the start of the letter where I have "Dear so and so" It actually just prints {ADVAVCE \y 240} on each page. Why would it do that? "Doug Robbins - Word MVP" wrote: Using Ctrl+F9 to insert each pair of field delimiters { IF { MERGEFIELD Address1 } = "text I want" { MERGEFIELD Unit } "" } The "" is not really necessary. Use Alt+F9 to toggle off the display of field codes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "BotR" wrote in message ... I’ve looked around here but couldn’t find the solution. I’m missing something. This is what I would like to accomplish; IF { MERGEFIELD Address1 } = “text I want” then insert { MERGEFIELD Unit }, If not as in something different, do nothing. I’m using Word and Excel 2003 Thanks |
#4
|
|||
|
|||
If Then Help Please
Are you sure that you used Ctrl+F9 to insert the field delimiters? Maybe
all you need to do is toggle off the display of field codes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "BotR" wrote in message news Thanks Doug, Odd, that's what I had and it didn't work. So I rebooted, tried a test with new Data and word doc, and it worked. Then I tried it again in the real doc and it worked. But now my {ADVAVCE \y 240} doesn't work. It is lower down at the start of the letter where I have "Dear so and so" It actually just prints {ADVAVCE \y 240} on each page. Why would it do that? "Doug Robbins - Word MVP" wrote: Using Ctrl+F9 to insert each pair of field delimiters { IF { MERGEFIELD Address1 } = "text I want" { MERGEFIELD Unit } "" } The "" is not really necessary. Use Alt+F9 to toggle off the display of field codes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "BotR" wrote in message ... I’ve looked around here but couldn’t find the solution. I’m missing something. This is what I would like to accomplish; IF { MERGEFIELD Address1 } = “text I want” then insert { MERGEFIELD Unit }, If not as in something different, do nothing. I’m using Word and Excel 2003 Thanks |
#5
|
|||
|
|||
If Then Help Please
Nice call Doug.
It was the toggle on the print preview, not actually printing. I would have never thought of toggle the display field on the preview. Don't go away, may need you if I get more creative.... I'll try to give you something more challenging next time. Thanks again. "Doug Robbins - Word MVP" wrote: Are you sure that you used Ctrl+F9 to insert the field delimiters? Maybe all you need to do is toggle off the display of field codes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "BotR" wrote in message news Thanks Doug, Odd, that's what I had and it didn't work. So I rebooted, tried a test with new Data and word doc, and it worked. Then I tried it again in the real doc and it worked. But now my {ADVAVCE \y 240} doesn't work. It is lower down at the start of the letter where I have "Dear so and so" It actually just prints {ADVAVCE \y 240} on each page. Why would it do that? "Doug Robbins - Word MVP" wrote: Using Ctrl+F9 to insert each pair of field delimiters { IF { MERGEFIELD Address1 } = "text I want" { MERGEFIELD Unit } "" } The "" is not really necessary. Use Alt+F9 to toggle off the display of field codes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "BotR" wrote in message ... I’ve looked around here but couldn’t find the solution. I’m missing something. This is what I would like to accomplish; IF { MERGEFIELD Address1 } = “text I want” then insert { MERGEFIELD Unit }, If not as in something different, do nothing. I’m using Word and Excel 2003 Thanks |
Thread Tools | |
Display Modes | |
|
|