Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Shelly Shelly is offline
external usenet poster
 
Posts: 26
Default using word 2007 suppress blank line when merge field is empty

Eg.
Not all records have an address2, need to skip blank line when this happens.
  #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 using word 2007 suppress blank line when merge field is empty

Use an If...then...Else field construction

{ IF { MERGEFIELD Address2 } = "" "{ MERGEFIELD City }, { MERGEFIELD State }
{ MERGEFIELD Zip }" "{ MERGEFIELD Address2 }[Enter]"{ MERGEFIELD City }, {
MERGEFIELD State } { MERGEFIELD Zip }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off their display. Insert a carriage return in the field
construction in place of the [Enter]

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

"Shelly" wrote in message
...
Eg.
Not all records have an address2, need to skip blank line when this
happens.



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
Mergefield suppress if data field blank JB reluctantly from WP Mailmerge 13 February 24th 09 03:36 AM
Word 2007 Address Block and Suppress Blank Lines JohnH Mailmerge 9 December 14th 07 01:15 PM
How do you suppress a line in word if merge fld is blank? Todd Mailmerge 6 July 21st 05 06:22 AM
line feed when merge field is blank Bev Mailmerge 1 March 22nd 05 10:31 PM
How do I add a space in a line if a merge field is blank? S Cocke Mailmerge 4 February 12th 05 12:13 AM


All times are GMT +1. The time now is 10:22 PM.

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"