Word 2007 Label Mail Merge Suppression Issue

[El Greco]

I am trying to create a mail merge document for labels. My spereadsheet
includes number of fields some with blank cells. In Word 2003 the blank
fields were supressed. In Word 2007 the appear as blank lines.

Is there anyway to fix this? I want to use the Mail Merge Wizard....i've
tried using the Address Block (which does suppress the blank fields) BUT the
structure isn't right for me as i want the persons name on the first line and
then the compnay.

 

[Doug Robbins - Word MVP]

Use an If...then...Else field construction to test for the existence of data
in the field that may be empty. For the true result, have it insert that
merge field, followed by a carriage return and then the next merge field.
For the negative result, have it insert the next merge field

{ IF { MERGEFIELD field1 } <> "" "{ MERGEFIELD field1 } [Enter]
{ MERGEFIELD field2 }" "{ MERGEFIELD field2 }" }

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

 

[El Greco]

Is there no way of utilising the Mail Mere Wizard to do this? I've never used
the If formulas to do a mail merge and it's confusing me bigtime - sorry.

Use an If...then...Else field construction to test for the existence of data
in the field that may be empty. For the true result, have it insert that
merge field, followed by a carriage return and then the next merge field.
For the negative result, have it insert the next merge field

{ IF { MERGEFIELD field1 } <> "" "{ MERGEFIELD field1 } [Enter]
{ MERGEFIELD field2 }" "{ MERGEFIELD field2 }" }

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

I am trying to create a mail merge document for labels. My spereadsheet
includes number of fields some with blank cells. In Word 2003 the blank
fields were supressed. In Word 2007 the appear as blank lines.

Is there anyway to fix this? I want to use the Mail Merge Wizard....i've
tried using the Address Block (which does suppress the blank fields) BUT
the
structure isn't right for me as i want the persons name on the first line
and
then the compnay.

 

[Graham Mayor]

No - you will have to insert the fields manually, using CTRL+F9 for each
field bracket pair, then type the rest (substituting the correct field names
from your data source). Press the enter key only where Doug has written
[Enter]

You could simplify Doug's construction:
{ MERGEFIELD field1 }{IF{ MERGEFIELD field2 } <> "" "[Enter]
{ MERGEFIELD field2 }"}{IF {{ MERGEFIELD field3 } <> "" "[Enter]
{ MERGEFIELD field3 }"} etc

- see http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm (which don't merely
concern labels).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Is there no way of utilising the Mail Mere Wizard to do this? I've
never used the If formulas to do a mail merge and it's confusing me
bigtime - sorry.

Use an If...then...Else field construction to test for the existence
of data in the field that may be empty. For the true result, have
it insert that merge field, followed by a carriage return and then
the next merge field. For the negative result, have it insert the
next merge field

{ IF { MERGEFIELD field1 } <> "" "{ MERGEFIELD field1 } [Enter]
{ MERGEFIELD field2 }" "{ MERGEFIELD field2 }" }

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

I am trying to create a mail merge document for labels. My
spereadsheet includes number of fields some with blank cells. In
Word 2003 the blank fields were supressed. In Word 2007 the appear
as blank lines.

Is there anyway to fix this? I want to use the Mail Merge
Wizard....i've tried using the Address Block (which does suppress
the blank fields) BUT the
structure isn't right for me as i want the persons name on the
first line and
then the compnay.