Home |
Search |
Today's Posts |
#1
|
|||
|
|||
suppressing blank address lines in mail merge
Source is SQL 2000 database where there are blank address lines before the
postcode. Is there a method of skipping blank lines resulting from blank fields in the Word document? |
#2
|
|||
|
|||
By default, Word suppresses blank lines where
a. there is at least one MERGEFIELD field on the line b. everything on the line evaluates to an empty string (i.e., there are no spaces, tabs, etc.) So I'd look for things that generate anything except an empty string... However, in Word 2002/3, if the MERGEFIELDs are nested inside another field, Word does not suppress blank lines and you will have to use IF fields to suppress them. Peter Jamieson "Geoff Holt" Geoff wrote in message ... Source is SQL 2000 database where there are blank address lines before the postcode. Is there a method of skipping blank lines resulting from blank fields in the Word document? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
can data fields be added to an exisiting mail merge address list | Microsoft Word Help | |||
How to omit blank lines in mail merge | Microsoft Word Help | |||
Correct address in mail merge | Microsoft Word Help |