Mail Merge with multiple address lines - Help

[Christi]

I am trying to merge with multiple address lines (MSWord 2003 -Form letter
and data source being used). I have the Address2 field that doesn't always
contain data but after merging it places a blank space for that field.
Example below:

«Sup_Title» «Sup_First_Name» «Sup_Last_Name» «JrSr»


«Title»
«School_Corporation»
«Address_1»
«Address_2»
«City», «State» «Zip»



After merge result below:



Mr. Walter Smith
Supervisor
Portview Township Schools
6240 US Hwy 6

Portage, IN 46368-5057

 

[Peter Jamieson]

Use Alt-F9 to reveal the field codes in your mail merge main document. Your
address lines will then look more like

{ MERGEFIELD Address_1 }
{ MERGEFIELD Address_2 }
{ MERGEFIELD City } etc.


Change this so it looks like:

{ MERGEFIELD Address_1
}{ IF "{ MERGEFIELD Address_2 }" = ""
"" "
{ MERGEFIELD Address_2 }" }
{ MERGEFIELD City } etc.

Every pair of {} must be the special field braces you can enter using
ctrl-F9, You can't just type the { and } on the keyboard.

NB it can actually look like

{ MERGEFIELD Address_1 }{ IF "{ MERGEFIELD Address_2 }" = "" "" "
{ MERGEFIELD Address_2 }" }
{ MERGEFIELD City } etc.

with an "enter" immediately before the second { MERGEFIELD Address_2 } but
the layout is easily lost in these newsgroup messages.

Use Alt-F9 to make those codes disappear/reappear as necessary.