Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How skip blank field
I have a bit of data in one of my fields that is blank. It's for an address
and it gives me an empty line when I merge. Is there a way to skip the blank field so that I don't have to go back to the merge to remove the blank line. There used to be a setting for this, but I can no longer find where that option is located (assuming it's still an option). Thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How skip blank field
Just thought I'd let you know I found the answer after plowing a little
further into other postings. The answer is in adding the old toolmerger tool (tools, customize, all commands ... find and add MailMergeHelper to your toolbar). That worked. Diana "Cowtoon" wrote in message ... I have a bit of data in one of my fields that is blank. It's for an address and it gives me an empty line when I merge. Is there a way to skip the blank field so that I don't have to go back to the merge to remove the blank line. There used to be a setting for this, but I can no longer find where that option is located (assuming it's still an option). Thanks. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How skip blank field
I take it back ... it's not working. boooooooooo!
"Cowtoon" wrote in message ... I have a bit of data in one of my fields that is blank. It's for an address and it gives me an empty line when I merge. Is there a way to skip the blank field so that I don't have to go back to the merge to remove the blank line. There used to be a setting for this, but I can no longer find where that option is located (assuming it's still an option). Thanks. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How skip blank field
Is the address data definitely completely blank?
What field codes are you using? Generally speaking, if Word won't blank your lines for you, you have to use an IF field to do it forr you, e.g. { IF "{ MERGEFIELD myfielda }" = "" "" " { MERGEFIELD myfielda }" }{ IF "{ MERGEFIELD myfieldb }" = "" "" " { MERGEFIELD myfieldb }" } and so on... All the {} need to be the special field codes that you can insert using ctrl-F9. Peter Jamieson "Cowtoon" wrote in message ... I take it back ... it's not working. boooooooooo! "Cowtoon" wrote in message ... I have a bit of data in one of my fields that is blank. It's for an address and it gives me an empty line when I merge. Is there a way to skip the blank field so that I don't have to go back to the merge to remove the blank line. There used to be a setting for this, but I can no longer find where that option is located (assuming it's still an option). Thanks. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How skip blank field
You can get around the problem by using an If...then...Else... field
construction that test for the presence of data in the field in question. If there is data, it inserts that field followed by a linefeed of carriage return and then the next merge field. If there is no data, it inserts the next field alone. { IF { MERGEFIELD fieldthatmightbeempty } "" "{ MERGEFIELD fieldthatmightbeempty } [Shift+Enter] { MERGEFIELD nextmergefield }" "{ MERGEFIELD nextmergefield }" } You must use Ctrl+F9 to insert each pair of field delimiters { } and you use Alt+F9 to toggle of 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 "Cowtoon" wrote in message ... I take it back ... it's not working. boooooooooo! "Cowtoon" wrote in message ... I have a bit of data in one of my fields that is blank. It's for an address and it gives me an empty line when I merge. Is there a way to skip the blank field so that I don't have to go back to the merge to remove the blank line. There used to be a setting for this, but I can no longer find where that option is located (assuming it's still an option). Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I skip blank fields in mail merge | Mailmerge | |||
Blank Merge Fields Still Print when told not to. | Mailmerge | |||
Mergefield with comma, suppress comma if field blank | Mailmerge | |||
IF command to insert a comma if the Title field is not blank | Mailmerge | |||
IF field blank, then insert different fields | Mailmerge |