Excel/Word Label Merge: format fields

[kaqgVT]

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

 

[Graham Mayor]

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.

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


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