Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
kaqgVT kaqgVT is offline
external usenet poster
 
Posts: 4
Default Excel/Word Label Merge: format fields

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
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert merge fields button doesn't show fields. Spin Dryer Mailmerge 5 September 27th 06 07:02 AM
mail merge, why 1 whole page of one contact? I want individual lab Melissa Mailmerge 6 September 19th 06 11:47 PM
mail merge putting fields in the wrong place! Disa Mailmerge 1 September 18th 06 09:24 AM
Format Fractions in Mail Merge. John McGhie [MVP - Word and Word Macintosh] Mailmerge 4 March 22nd 06 08:55 AM
Populate Merge Fields via VB.NET ben Mailmerge 5 June 21st 05 05:43 PM


All times are GMT +1. The time now is 11:05 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"