[macropod[_2_]]

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