| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
If Then Help Please
Ive looked around here but couldnt find the solution. Im 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. Im using Word and Excel 2003 Thanks |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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 ... Ive looked around here but couldnt find the solution. Im 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. Im using Word and Excel 2003 Thanks |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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 ... Ive looked around here but couldnt find the solution. Im 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. Im using Word and Excel 2003 Thanks |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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 ... Ive looked around here but couldnt find the solution. Im 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. Im using Word and Excel 2003 Thanks |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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 ... Ive looked around here but couldnt find the solution. Im 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. Im using Word and Excel 2003 Thanks |
Linear Mode
