Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Blank Fields in Word 2007 Merge
Hi there,
When merging data from Excel 2007 into a document in Word 2007, some of the fields are blank,... I want to remove the blanks and move the rest of the info up. I am doing addresses and sopme addresses are over 4 lines and others over 5,... we don't want a space if there is no data in line 4 (for example) Help..... Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Blank Fields in Word 2007 Merge
You need to use an If...then...Else field construction
{ IF { MERGEFIELD mergefieldthatmightbeblank } "" "{ MERGEFIELD mergefieldthatmightbeblank }¶ { MERGEFIELD mergefieldthatcomesaftermergefieldthat mightbeblank }" "{ MERGEFIELD mergefieldthatcomesaftermergefieldthat mightbeblank }" } You must use Ctrl+F9 to insert each pair of field delimiters { } and where ¶ appears in the above, press the Enter key. Use Alt+F9 to toggle off the display of the field codes. -- 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 "Promo" wrote in message ... Hi there, When merging data from Excel 2007 into a document in Word 2007, some of the fields are blank,... I want to remove the blanks and move the rest of the info up. I am doing addresses and sopme addresses are over 4 lines and others over 5,... we don't want a space if there is no data in line 4 (for example) Help..... Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2007 Mail Merge Labels skips fields using update fields | Mailmerge | |||
Word 2007 Blank fields | Mailmerge | |||
How can I insert a placeholder for blank Word merge fields? | Mailmerge | |||
Word mail merge should suppress blanks left by blank fields. | Mailmerge | |||
How to supress blank merge fields in Word 2002 | Microsoft Word Help |