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.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Christi" wrote in message
...
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