Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Another line suppression issue in Word 2007 | Mailmerge | |||
Mail merge with Excel 2007 will not print but 1 label!! | Mailmerge | |||
Mail Merge issue with Return Label and Foreign Address | Mailmerge | |||
Mail Merge issue with Word 2003 | Mailmerge |