[Adam]

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[_2_]]

Suzanne talks about it under "Customize the mail merge toolbar..." he
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Adam" wrote in message
...
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

[Adam]

Sorry that didnt help or work.

"Anne Troy" wrote:

Suzanne talks about it under "Customize the mail merge toolbar..." he
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Adam" wrote in message
...
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

[Peter Jamieson]

Which version of Word are you using?

Peter Jamieson
"Adam" wrote in message
...
Sorry that didnt help or work.

"Anne Troy" wrote:

Suzanne talks about it under "Customize the mail merge toolbar..." he
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Adam" wrote in message
...
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

[Adam]

Hi,

I have tried it in 2000 and 2002 sp 3

Regards

Adam

"Peter Jamieson" wrote:

Which version of Word are you using?

Peter Jamieson
"Adam" wrote in message
...
Sorry that didnt help or work.

"Anne Troy" wrote:

Suzanne talks about it under "Customize the mail merge toolbar..." he
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Adam" wrote in message
...
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

[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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Adam" wrote in message
...
Hi,

I have tried it in 2000 and 2002 sp 3

Regards

Adam

"Peter Jamieson" wrote:

Which version of Word are you using?

Peter Jamieson
"Adam" wrote in message
...
Sorry that didnt help or work.

"Anne Troy" wrote:

Suzanne talks about it under "Customize the mail merge toolbar..."
he
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Adam" wrote in message
...
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