[Red Sapphire]

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

[Doug Robbins - Word MVP]

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

[Kathy Mergulhao]

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

[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