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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martha - 21 Aug 2005 12:05 GMT

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

Reply to this Message

Graham Mayor - 21 Aug 2005 14:48 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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,
[quoted text clipped - 7 lines]
> Little Beach, NJ 00000
> Little Beach, NJ 00000

Reply to this Message

Doug Robbins - 21 Aug 2005 14:59 GMT

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

Signature

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

> When I set up excel for mail merge I encountered the problem of not
> knowing
[quoted text clipped - 7 lines]
> Little Beach, NJ 00000
> Little Beach, NJ 00000

Reply to this Message

Rate this thread: