A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

If Then Help Please



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2010, 02:54 AM posted to microsoft.public.word.mailmerge.fields
BotR
external usenet poster
 
Posts: 9
Default 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  
Old April 24th, 2010, 03:10 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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
...
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  
Old April 24th, 2010, 06:08 AM posted to microsoft.public.word.mailmerge.fields
BotR
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
...
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  
Old April 24th, 2010, 10:29 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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
...
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  
Old April 24th, 2010, 04:40 PM posted to microsoft.public.word.mailmerge.fields
BotR
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
...
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.