[ISSBA]

I have an excel document that is my source. It has several fields set up for
names and $ amounts. When I merge that to my Word if any of the fields
should be blank, and are blank on the excel, the merge isn't leaving it
blank. Instead it shifts the next line up into the blank lines place.

How do I format the field to keep the blank and not shift the next line's
data up?

[Peter Jamieson]

Which version of Word/Excel?

How are you connecting? (It doesn't matter if you do not know the answer to
this one.)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"ISSBA" wrote in message
...
I have an excel document that is my source. It has several fields set up
for
names and $ amounts. When I merge that to my Word if any of the fields
should be blank, and are blank on the excel, the merge isn't leaving it
blank. Instead it shifts the next line up into the blank lines place.

How do I format the field to keep the blank and not shift the next line's
data up?

[Rich/rerat]

ISSBA,
Try this, it works in Word 2003:

Line1: { MERGEFIELD "First_Name" } { MERGEFIELD "Last_Name" }
Line2: { if{ MERGEFIELD "Company" }= "" "" { MERGEFIELD "Company" } }
Line3:{ MERGEFIELD "Street" }
Line4:{ MERGEFIELD "City" }, { MERGEFIELD "State" } { MERGEFIELD
"Postal_Code" }

{ MERGEFIELD "Company" } is the Mergefield that can be blank, substitute the
Field name that represents your Data.
--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat (RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Peter Jamieson" wrote in message
...
Which version of Word/Excel?

How are you connecting? (It doesn't matter if you do not know the answer to
this one.)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"ISSBA" wrote in message
...
I have an excel document that is my source. It has several fields set up
for
names and $ amounts. When I merge that to my Word if any of the fields
should be blank, and are blank on the excel, the merge isn't leaving it
blank. Instead it shifts the next line up into the blank lines place.

How do I format the field to keep the blank and not shift the next line's
data up?

[ISSBA]

Sorry, I should have mentioned this before, both programs are 2007 versions
within Office 2007.

"Peter Jamieson" wrote:

Which version of Word/Excel?

How are you connecting? (It doesn't matter if you do not know the answer to
this one.)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"ISSBA" wrote in message
...
I have an excel document that is my source. It has several fields set up
for
names and $ amounts. When I merge that to my Word if any of the fields
should be blank, and are blank on the excel, the merge isn't leaving it
blank. Instead it shifts the next line up into the blank lines place.

How do I format the field to keep the blank and not shift the next line's
data up?

[Peter Jamieson]

In that case, Rich/rerat's answer is probably the way to go, e.g.
if you are using

{ MERGEFIELD "Last_Name" }
{ MERGEFIELD "Company" }
{ MERGEFIELD "Street" }
{ MERGEFIELD "Postal_Code" }

then if "Street" is blank, you will get the same as if you used

{ MERGEFIELD "Last_Name" }
{ MERGEFIELD "Company" }
{ MERGEFIELD "Postal_Code" }

That's how Word works by default.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"ISSBA" wrote in message
...
Sorry, I should have mentioned this before, both programs are 2007
versions
within Office 2007.

"Peter Jamieson" wrote:

Which version of Word/Excel?

How are you connecting? (It doesn't matter if you do not know the answer
to
this one.)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"ISSBA" wrote in message
...
I have an excel document that is my source. It has several fields set
up
for
names and $ amounts. When I merge that to my Word if any of the fields
should be blank, and are blank on the excel, the merge isn't leaving it
blank. Instead it shifts the next line up into the blank lines place.

How do I format the field to keep the blank and not shift the next
line's
data up?

[macropod[_2_]]

Hi Peter,

As I understand the OP's post, the problem is that the lines for empty fields are being deleted, but the OP wants them retained.

--
Cheers
macropod
[MVP - Microsoft Word]


"Peter Jamieson" wrote in message ...
In that case, Rich/rerat's answer is probably the way to go, e.g.
if you are using

{ MERGEFIELD "Last_Name" }
{ MERGEFIELD "Company" }
{ MERGEFIELD "Street" }
{ MERGEFIELD "Postal_Code" }

then if "Street" is blank, you will get the same as if you used

{ MERGEFIELD "Last_Name" }
{ MERGEFIELD "Company" }
{ MERGEFIELD "Postal_Code" }

That's how Word works by default.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"ISSBA" wrote in message
...
Sorry, I should have mentioned this before, both programs are 2007
versions
within Office 2007.

"Peter Jamieson" wrote:

Which version of Word/Excel?

How are you connecting? (It doesn't matter if you do not know the answer
to
this one.)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"ISSBA" wrote in message
...
I have an excel document that is my source. It has several fields set
up
for
names and $ amounts. When I merge that to my Word if any of the fields
should be blank, and are blank on the excel, the merge isn't leaving it
blank. Instead it shifts the next line up into the blank lines place.

How do I format the field to keep the blank and not shift the next
line's
data up?