Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
DeeDeeCee DeeDeeCee is offline
external usenet poster
 
Posts: 41
Default Can "content" be incorporated into a REF field?


I have a letter template in which the " xxxx" line sometimes should
include an account number. I can put in a REF field that will automatically
enter the account number from another place in the document, with a bookmark
around it. I want to have the language "Account Number" in front of the
actual number in the xxxx line, if I do so.

The problem is that sometimes there is no account number, and in those cases
I DON'T want the words "Account Number" to appear, as there will be nothing
after it.

Thanks for any advice.

ddc

Is there any way to set up the template and/or the REF field so that if
there is an account number, the words "Account Number" appear, followed by
the actual number...but if there is no account number in the bookmark, then
nothing at all appears in the xxxx line?
  #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 Can "content" be incorporated into a REF field?

{ IF { REF [bookmark] } "" " Account Number { REF [bookmark] }" "" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
A;t+F9 to toggle off their display.

--
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

"DeeDeeCee" wrote in message
...

I have a letter template in which the " xxxx" line sometimes should
include an account number. I can put in a REF field that will
automatically
enter the account number from another place in the document, with a
bookmark
around it. I want to have the language "Account Number" in front of the
actual number in the xxxx line, if I do so.

The problem is that sometimes there is no account number, and in those
cases
I DON'T want the words "Account Number" to appear, as there will be
nothing
after it.

Thanks for any advice.

ddc

Is there any way to set up the template and/or the REF field so that if
there is an account number, the words "Account Number" appear, followed by
the actual number...but if there is no account number in the bookmark,
then
nothing at all appears in the xxxx line?


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default Can "content" be incorporated into a REF field?

When I tested that here a while ago, I found that if [bookmark] doesn't
exist, the expression resolves as FALSE. I'm guessing {Ref [bookmark]} must
return an error message (internally). So, if the account number doesn't
appear, the user will need to bookmark a point in the document, so it can
properly compare as TRUE to "" when there is no account number.

--
Herb Tyson MS MVP
Author of the Word Bible
Blog: http://word.herbtyson.com
Web: http://www.herbtyson.com

"Doug Robbins - Word MVP" wrote in message
...
{ IF { REF [bookmark] } "" " Account Number { REF [bookmark] }" "" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
A;t+F9 to toggle off their display.

--
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

"DeeDeeCee" wrote in message
...

I have a letter template in which the " xxxx" line sometimes should
include an account number. I can put in a REF field that will
automatically
enter the account number from another place in the document, with a
bookmark
around it. I want to have the language "Account Number" in front of the
actual number in the xxxx line, if I do so.

The problem is that sometimes there is no account number, and in those
cases
I DON'T want the words "Account Number" to appear, as there will be
nothing
after it.

Thanks for any advice.

ddc

Is there any way to set up the template and/or the REF field so that if
there is an account number, the words "Account Number" appear, followed
by
the actual number...but if there is no account number in the bookmark,
then
nothing at all appears in the xxxx line?


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Can "content" be incorporated into a REF field?

If the bookmark does not exist a further test is required

{ IF { REF Number } "Error!*" "{ IF { REF Number } "" " Account
Number { REF Number }" } }

where Number is the bookmark name.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"Herb Tyson [MVP]" wrote in message
...
When I tested that here a while ago, I found that if [bookmark] doesn't
exist, the expression resolves as FALSE. I'm guessing {Ref [bookmark]}
must return an error message (internally). So, if the account number
doesn't appear, the user will need to bookmark a point in the document, so
it can properly compare as TRUE to "" when there is no account number.

--
Herb Tyson MS MVP
Author of the Word Bible
Blog: http://word.herbtyson.com
Web: http://www.herbtyson.com

"Doug Robbins - Word MVP" wrote in message
...
{ IF { REF [bookmark] } "" " Account Number { REF [bookmark] }"
"" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
A;t+F9 to toggle off their display.

--
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

"DeeDeeCee" wrote in message
...

I have a letter template in which the " xxxx" line sometimes should
include an account number. I can put in a REF field that will
automatically
enter the account number from another place in the document, with a
bookmark
around it. I want to have the language "Account Number" in front of the
actual number in the xxxx line, if I do so.

The problem is that sometimes there is no account number, and in those
cases
I DON'T want the words "Account Number" to appear, as there will be
nothing
after it.

Thanks for any advice.

ddc

Is there any way to set up the template and/or the REF field so that if
there is an account number, the words "Account Number" appear, followed
by
the actual number...but if there is no account number in the bookmark,
then
nothing at all appears in the xxxx line?




Reply
Thread Tools
Display Modes

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the content of field "Company" ? Skipper Microsoft Word Help 1 February 7th 08 01:58 PM
how do I set up a "expand/collapse" or "show/hide" field in Word WordDoc_FeatureUser Microsoft Word Help 2 May 12th 07 06:29 PM
"Print current page" should have a "+n pages" field. rawahoho Microsoft Word Help 5 November 16th 06 03:26 PM
"h" and "t" allowed in form Number field Lori S Microsoft Word Help 1 October 17th 06 10:49 PM
New field for Word: {SCREENTIP "DisplayText" "TipText"} DQC from Prescott AZ Microsoft Word Help 1 March 17th 06 11:29 PM


All times are GMT +1. The time now is 01:07 AM.

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

About Us

"It's about Microsoft Word"