[Doug Robbins - Word MVP]

Where I used the { MERGEFIELD nextmergefield } you need to use the actual
next merge field.

--
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, originally posted via msnews.microsoft.com
"Yookaroo" wrote in message
...
Not sure what happened to my first question either.. Heck I cant even
remember what it was.

Anyways this is a big help, where you say nextmergefield, do I put the
name
of the next field in or just leave it as is?

As for the find replace I spent the last couple of hours find replacing
into
the excel file which is now huge but working.

Thanks again

"Doug Robbins - Word MVP" wrote:

Not sure what happened to your first question, but for the second one,
use
an If...then...Else field construction

{ IF { MERGEFIELD "nameoffieldthatmightbeempty" } ="" "{ MERGEFIELD
"nextmergefield" }" "{ MERGEFIELD "nameoffieldthatmightbeempty" }¶
{ MERGEFIELD "nextmergefield" }" }

where the ¶ appears in the above construction, press the Enter key. You
must use Ctrl+F9 to insert each pair of the field delimiters { } and use
Alt+F9 to toggle off their display.

For your second (sorry third) question, while you may be able to set up a
new sheet in Excel that references the data in the existing sheet, using
a
Function to move things over, a low tech way of doing it would be to sort
the data by as many fields as your version of Excel will allow (that is
by
the second, then the third, then the fourth, etc) then select and delete
each of the empty blocks of cells, moving the data to the left.