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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge 1
Label mail merge 1
mail Merge & Excel Y or N 2
Mail Merge and Print Data Only for Forms 2
Mail Merge Word 2007 2
Mail Merge 4
Mail Merge 2
Mail merge is Maxed 1

Back
Top