View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
StargateFan[_2_] StargateFan[_2_] is offline
external usenet poster
 
Posts: 12
Default Name of featu when field is empty, rest of info "slides" ...

On Fri, 29 May 2009 07:48:36 +1000, "Doug Robbins - Word MVP"
wrote:

This can be controlled in Word by the use of an If...then...Else field that
tests for the existence of data in a field that may be blank and either
inserts the contents if there are any, or moves on to the next field if
there are not. If there are contents in the field, the result for that
condition will also need to include a space or a carriage return as
appropriate for the context.

For example, if you have fname, initial and lname fields and there may or
may not be contents in the initial field, you would use

{ MERGEFIELD fname } { IF { MERGEFIELD initial } "" "{ MERGEFIELD
initial } { MERGEFIELD lname }" "{ MERGEFIELD lname }" }

If you had address1, address2, city fields and you did not want a blank line
if address2 was empty, you would use

{ MERGEFIELD address1}
{ IF { MERGEFIELD address2 } "" "{ MERGEFIELD address 2 }¶
{ MERGEFIELD city }" "{ MERGEFIELD city }" }

In the above, where the ¶ appears, you would need to press the Enter key (or
Shift + Enter)

In all cases, the { } must be inserted using Ctrl+F9. It will NOT work if
they are entered using the keys for those symbols on the keyboard. You use
Alt + F9 to toggle the display of the field codes.

--
Hope this helps.


Thank you! I believe it will. I'll take the information to work
tomorrow and we'll give it a try.

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
wrote in message
...
... up or to the left so that there are no blank spaces.

In Filemaker Pro (FMP), if memory serves, this is called "slide" or
"sliding". What would the term be in Word 2007, pls? I need to find
out how to code for blank data. There must be a way to emulate this
in a word processing doct., vs. a database such as FMP.

Thanks!

D