[Doug Robbins - Word MVP]

If the arrangement of the fields is correct in Word, then I would agree that
it must be a bug in Excel. Phew!

--
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

"Onalee" wrote in message
...
Hi,
No, the data is not in the wrong fields. If I go back to the the original
way to connect (OLB?) they go back to the right places on the word
erge - I
did not change where they were in the excel sheet,just changed to DDE.

Apparently, this is just some cruel bug in excel that I'll just have to
deal
with.

Onalee

"Doug Robbins - Word MVP" wrote:

It seems like you must have the mergefields in the wrong columns.

--
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

"Onalee" wrote in message
...
Hi,
Ok, I tried changing the format of the column as you describe, that
didn't
help, so I changed the way word connects to excel to DDE as described
in
one
of the links. That fixed this problem but created a much larger
problem.

I have 3 columns in a table in word. There is one field per column
merged
from excel, the three fields are : Product 1, q1 and p1 . Now, where
q1
is
supposed to be, it is putting the data from the field Product 1 and
where
p1
is supposed to be, it is putting the data from q1 and where Product 1
is
supposed to be it is putting the data from p1. It's got them all
messed
up
somehow in the mapping or something.

I think it was better the other way, at least that was just one field
messed
up and only sometimes.

any other thoughts?

Thanks,
Onalee

"Peter Jamieson" wrote:

It's possible that you have encountered a new problem that is not
described
at http://tips.pjmsn.me.uk/t0003.htm, but it may be worth trying this
suggestion from that page on your Excel sheet (or one of the following
suggestions):


1. Format a column as text via Data|Text to Columns...

If you have a mixture of numbers and texts in a column but numbers in
the
first 8 rows, you may need to get the OLE DB provider to "see" the
column
as
a text column. However, selecting the column and using Format|Cells to
set
the format as Text does not appear to be enough. One way that does
appear
to
work is
- select the column
- select the Data|Text to Columns... menu option
- click Next through the wizard until you reach Step 3 of 3, then
select
Text as the Column Data Format.



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

"Onalee" wrote in message
...
Hi,
I am merging data from excel into a word document. I am getting
data
in
word that is showing "12:00AM", however, there is data in the excel
sheet
and
it is NOT a date and it is not blank - it is part of an address
line,
such
as
"Deliver to Front Desk" or any kinds of words, but definately not a
date
and
not blank.

I have tried re-typing the data in excel, I have even put a " ' " in
front
of it to show it is text - nothing gets rid of this . It doesn't do
it
on
every field or even every record on the same field, just some and
seemingly
randomly.

Any idea how to fix this other than manually changing the data in
the
final
merged document?

Thanks ,
Onalee