Mail Merge Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am having poblems with mail merge i have put the following feilds ina
document:

«First Name» «Last Name»
«First_line_of_address»
«Second_Line»
«City»
«County»
«Country»
«Postcode»


They are all linked to excel, but the problem i have is that when i merge
the fields that are blank do not delete although i have seleced them not to
print in word.

Fo example some people might not have a second line of address so it will
show as blank in word but should not print blank in print run but should
delete the blank field instead.

Hope that makes sense i just don't know what i am doing wrong.

Adam
 
Blank lines are not suppressed if they end in line breaks, only if they end
in paragraph breaks. If you want to end the lines with line breaks, then you
need to insert the merge field *and* the line break in an IF field that
tests for blankness.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Back
Top