Optional field on labels Word 2002

[Ed]

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

 

[Doug Robbins - Word MVP]

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]

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]

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/cindymeister/MergFram.htm


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

 

[Graham Mayor]

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