Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
leave a blank line when merging
Using Excel XP and Word XP, how can I force a blank line when there is no
data? ie, i want to leave a line for a user to pencil-in data where none exists in the database. -- haf |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
leave a blank line when merging
Does your line just consist of a single field?
If you want /all/ blank fields to result in blank lines then go into Word Tools|Customize|Commands, select category "All COmmands", then locate MailMergeHelper in the list of commands and drag it to a toolbar. Click on it, then click Merge... and select the appropriate option. If you want /some/ (or all) blank fields to result in blank lines then nest the field inside an IF field, e.g. { IF "{ MERGEFIELD myfield }" = "" "" "{ MERGEFIELD myfield }" } where all the {} are the special field brace characters you can insert using ctrl-F9 Peter Jamieson "stlof" wrote in message news Using Excel XP and Word XP, how can I force a blank line when there is no data? ie, i want to leave a line for a user to pencil-in data where none exists in the database. -- haf |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
leave a blank line when merging
Thanks.
no, i'm merging what amounts to a small table. cells contain information or are blank. there is no problem when any cell has data, the problem arises when all are blank. let's se if i can demonstrate: n blank blank blank results in a line with n in the first column, however blank blank blank blank leaves no line. any better? haf "Peter Jamieson" wrote: Does your line just consist of a single field? If you want /all/ blank fields to result in blank lines then go into Word Tools|Customize|Commands, select category "All COmmands", then locate MailMergeHelper in the list of commands and drag it to a toolbar. Click on it, then click Merge... and select the appropriate option. If you want /some/ (or all) blank fields to result in blank lines then nest the field inside an IF field, e.g. { IF "{ MERGEFIELD myfield }" = "" "" "{ MERGEFIELD myfield }" } where all the {} are the special field brace characters you can insert using ctrl-F9 Peter Jamieson "stlof" wrote in message news Using Excel XP and Word XP, how can I force a blank line when there is no data? ie, i want to leave a line for a user to pencil-in data where none exists in the database. -- haf |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging blank cells from excel to word i want them to stay blank n | Mailmerge | |||
Widowed line in a table | Tables | |||
line feed when merge field is blank | Mailmerge | |||
How to skip line numbers for all blank lines in a document | Page Layout | |||
Change Line Count to not count blank lines | Microsoft Word Help |