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