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

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

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

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


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

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

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