Excel/Word Label Merge: format fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kaqgVT - 20 Nov 2006 23:02 GMT

I am setting up labels to apply to my Rolodex cards, and have formatted and
merged all data successfully, but on records for which fields are blank, the
"Label" prints the next field immediately following the previous. I want the
space for the field to remain on the label, even if there's no data.
i.e.:label 1st line: [Company]; 2nd line [FN],[LN], [Title]; 3rd: [add],
[city] [st]...
If no FN/LN, then displays:
ABC, Inc
123 Some Road, etc.
And I want there to be a space where FN/LN/Title would be.

Is the only option to type a field name on the label that will display on
each line? I had written my field names into the Edit Fields/Options area,
which adjusts for various-lengthed data.

Oh muddle. I guess the last time I tried this was in MS Works... and there
was a command to "slide" or "move" up over blanks.

Any suggestions will be greatly appreciated.
Thanks

Reply to this Message

Graham Mayor - 21 Nov 2006 06:15 GMT

If you put a hard return at the end of your first and second lines that hard
return should remain in the merge.
{Mergefield Company}¶
{Mergefield FN},{Mergefield LN},{Mergefield Title}¶
{Mergefield Address} etc

This will also leave the commas in line 2 so you may want to remove those if
the data doesn't exist eg
{IF{Mergefield FN} <> "" "{Mergefield FN},"} {IF{Mergefield LN} <> ""
"{Mergefield LN},"} {Mergefield Title}¶

This will still leave space if the fields are missing but not the commas.

Signature

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

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

> I am setting up labels to apply to my Rolodex cards, and have
> formatted and merged all data successfully, but on records for which
[quoted text clipped - 16 lines]
> Any suggestions will be greatly appreciated.
> Thanks

Reply to this Message