Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BotR BotR is offline
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BotR BotR is offline
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BotR BotR is offline
external usenet poster
 
Posts: 9
Default 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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 11:28 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"