View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Optional field on labels Word 2002

I think you have quoted the wrong link from my web site? Try
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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

Doug Robbins - Word MVP wrote:
Look at the articles on fellow MVPs Graham Mayor's website at
http://www.gmayor.com/multiple_mail_merge_entries.htm

and Cindy Meisters at
http://homepage.swissonline.ch/cindy...r/MergFram.htm



"Ed" wrote in message
...

Thanks, Doug. I'll give it a try. Is there someplace where one can
read about the full
richness of the mailmerge syntax? Word Help seems oriented entirely
toward the
wizard.

Ed


"Doug Robbins - Word MVP" wrote in message
...

Use an If...then...Else field

{ IF { MERGEFIELD Spouse } "" " & { MERGEFIELD Spouse }" "" }

Use Ctrl+F9 to insert each pair of field delimiters {} and Alt+F9 to
toggle off their display.

--
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

"Ed" wrote in message
...

I'm trying to create mailing lables in which would include a field
only if it is non-blank.
Also, the preceding separator would be omitted if the field is
blank. E.g.,

James & Mary Brown
...
...

or

Bill Smith
...
...

As opposed to

Bill & Smith
...
...

How can this be done when setting up the label layout?

The source data is in an Excel spreadsheet. I know the basics of
the process.


TIA

Ed