View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
GregNga GregNga is offline
external usenet poster
 
Posts: 23
Default Ignore blank address fields

Here is how I want to format the envelope:


Title Firstname Lastname
Addr1
Addr2
City State Zip

I only want to print the line with Addr2 if it is non-blank. How do I format
my document using If, Then Else


"Doug Robbins - Word MVP" wrote:

You will need to use an If...then...Else field construction

{ IF { MERGEFIELD field2 } = "" "{ MERGEFIELD field3 }" "{ MERGEFIELD
field2 }¶
{ MERGEFIELD field3 }" }

You must use Ctrl+F9 to insert each pair of field delimiters and where the ¶
appears in the above, you need to press the Enter key or Shift + Enter.

Use Alt+F9 to toggle off the display of the 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

"GregNga" wrote in message
...
How to I get Word mail merge to ignore blank address fields. In other
words,
If address field 2 is blank, I don't want to priht a blank line