Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Supressing empty lines in Word 2003 during a mail merge
Hi all,
I know that there is a button somewhere, that leaves out empty fields during a mail merge thus ensuring that you don't get empty lines or spaces when you merge a document? Any help much appreciated! Thank you Alison |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Supressing empty lines in Word 2003 during a mail merge
I don't know if there's a button or not - it not being something that I have
ever relied upon. Instead, I use If...then...Else field constructions such as { IF { MERGEFIELD Address2 } "" "{ MERGFIELD Address2 }¶ { MERGEFIELD City } { MERGEFIELD State } { MERGEFIELD Zip }" "{ MERGEFIELD City } { MERGEFIELD State } { MERGEFIELD Zip }" } In such a construction, you must use Ctrl+F9 to insert each pair of field delimiters { } and where the ¶ appears in the above, press the Enter Key, or Shift+Enter. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Red Sapphire" wrote in message ... Hi all, I know that there is a button somewhere, that leaves out empty fields during a mail merge thus ensuring that you don't get empty lines or spaces when you merge a document? Any help much appreciated! Thank you Alison |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Suppressing lines in Word Mail Merge
I am looking for the same answer... hopefully someone will know if it can be done.
I am merging Excel data into a Word 2003 table. Each cell contains an If statement. If some of the rows are not needed, therefore empty, I would like the empty row to be deleted from the table. Is it possible? Red Sapphire wrote: Supressing empty lines in Word 2003 during a mail merge 17-Dec-09 Hi all, I know that there is a button somewhere, that leaves out empty fields during a mail merge thus ensuring that you do not get empty lines or spaces when you merge a document? Any help much appreciated! Thank you Alison Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Build a Custom .NET "EVAL" Provider http://www.eggheadcafe.com/tutorials...-net-eval.aspx |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Suppressing lines in Word Mail Merge
Hi Kathy,
Did you read Doug's reply? Personally, I'd simplify the code to: { IF {MERGEFIELD Address2} "" "{MERGFIELD Address2}¶ "}{MERGEFIELD City} {MERGEFIELD State} {MERGEFIELD Zip} or: { IF «Address2» "" "«Address2»¶ "}«City» «State» «Zip» Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likwise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. -- Cheers macropod [Microsoft MVP - Word] "Kathy Mergulhao" wrote in message ... I am looking for the same answer... hopefully someone will know if it can be done. I am merging Excel data into a Word 2003 table. Each cell contains an If statement. If some of the rows are not needed, therefore empty, I would like the empty row to be deleted from the table. Is it possible? Red Sapphire wrote: Supressing empty lines in Word 2003 during a mail merge 17-Dec-09 Hi all, I know that there is a button somewhere, that leaves out empty fields during a mail merge thus ensuring that you do not get empty lines or spaces when you merge a document? Any help much appreciated! Thank you Alison Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Build a Custom .NET "EVAL" Provider http://www.eggheadcafe.com/tutorials...-net-eval.aspx |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove empty lines from a label mail merge | Mailmerge | |||
supressing warning when opening a Word Mail Merge document from Access | Mailmerge | |||
How do I remove blank lines in mail merge labels in Word 2003 | Mailmerge | |||
In Word 2003 when mail merge how do I delete an empty field? | Mailmerge | |||
How do I avoid printing blank lines using mail merge in Word 2003. | Mailmerge |