mail merge formatting

[beauquai]

I am doing a mail merge to print a few thousand labels. Is there a way for me to tell the document to SKIP blank fields? For example, if there is no Address Line 2, I don't want a blank line in the merge - I want the City, State & Zip line to move UP.

 

[John McGhie]

Yes. See here:
http://word.mvps.org/faqs/mailmerge/MMergeIfFields.htm

That's written for Word 97, but the techniques still work.

Cheers

I am doing a mail merge to print a few thousand labels. Is there a way for me
to tell the document to SKIP blank fields? For example, if there is no Address
Line 2, I don't want a blank line in the merge - I want the City, State & Zip
line to move UP.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:[email protected]

 

[CyberTaz]

That should be the default behavior if what you're referring to as Address
Line 2 contains nothing but one or more empty field(s). (This is assuming
that you're not using a very old version of Word - at one time the behavior
was just the opposite & a special setting had to be used to shift lines up.)

For example, if your label setup is something like:

<<First Name>> <<Last Name>>
<<Address1>>
<<Address2>>
<<City>>, <<State>> <<Zip>>

City, State & Zip will shift up if there is no content in the Address2 field
for any given record - the blank field won't create a blank line.

OTOH, if you have something like:

<<First Name>> <<Last Name>>
<<Address1>>
<<Rural Route>> <<PO Box>>
<<City>>, <<State>> <<Zip>>

the third line will "print" (as a blank line) even if both fields are empty
because of the [sp] between the two fields. The article John pointed you to
addresses this.

HTH |:>)
Bob Jones
[MVP] Office:Mac