How to merge labels when some addresses have 3 lines others 4

[Martha]

When I set up excel for mail merge I encountered the problem of not knowing
what to do in cases where I have some addresses with 3 lines, others with 4.

Examples: John Doe others Jhn Doe
Manor Hospital 345
Main St
345 Main St.
Little Beach, NJ 00000
Little Beach, NJ 00000

 

[Graham Mayor]

I assume that you have a problem with unwanted spaces?
You could make the extra address line into a conditional field eg

{Mergefield Add1}{IF {Mergefield Add2} <> "" "
{Mergefield Add2}"}
{Mergefield Add3}
{Mergefield Add4}

Use CTRL+F9 to insert field boundaries and substitute the fields names from
your data file.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Doug Robbins]

Just insert all four mergefields into the label. If a field is empty, the
mailmerge will ignore it.

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP