Reply
 
Thread Tools Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Excel/Word Label Merge: format fields

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

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


kaqgVT wrote:
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
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 04:37 PM.

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"