Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
El Greco El Greco is offline
external usenet poster
 
Posts: 1
Default Word 2007 Label Mail Merge Suppression Issue

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2007 Label Mail Merge Suppression Issue

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" El wrote in message
...
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.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
El Greco[_2_] El Greco[_2_] is offline
external usenet poster
 
Posts: 1
Default Word 2007 Label Mail Merge Suppression Issue

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.

"Doug Robbins - Word MVP" wrote:

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" El wrote in message
...
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.




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Word 2007 Label Mail Merge Suppression Issue

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_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm (which don't merely
concern labels).

--

Graham Mayor - Word MVP

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



El Greco wrote:
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.

"Doug Robbins - Word MVP" wrote:

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" El wrote in message
...
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.



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
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
Another line suppression issue in Word 2007 Oldsfan Mailmerge 2 January 23rd 08 03:06 PM
Mail merge with Excel 2007 will not print but 1 label!! anne6marie Mailmerge 1 December 18th 07 08:39 PM
Mail Merge issue with Return Label and Foreign Address Rocketman Mailmerge 3 December 14th 06 07:28 AM
Mail Merge issue with Word 2003 Srinivasan.B Mailmerge 9 October 26th 06 02:46 PM


All times are GMT +1. The time now is 11:43 AM.

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"