Mail Merge Help

[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

 

[Anne Troy]

Suzanne talks about it under "Customize the mail merge toolbar..." here:
http://sbarnhill.mvps.org/WordFAQs/ExpressMailMerges.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[Guest]

Sorry that didnt help or work.

Suzanne talks about it under "Customize the mail merge toolbar..." here:
http://sbarnhill.mvps.org/WordFAQs/ExpressMailMerges.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[Peter Jamieson]

Which version of Word are you using?

Peter Jamieson

 

[Guest]

Hi,

I have tried it in 2000 and 2002 sp 3

Regards

Adam

 

[Suzanne S. Barnhill]

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.