thanks Peter,
I'm not sure if this sort of thing will work, as we are merging sheet 1 & 2
seperately but with the intention of sorta doin the same thing.
I've figured out that the cell information stops at 255 characters when
converted int Word. I somehow need to extend this amount if possible,
unfortunately theahrsh reality looks like I can't do that and will need to
split the cells. Only problems there is there is so much data in the column
that this is a problem with, it doesn't seem viable.
Any ideas??
"Peter Jamieson" wrote:
See http://tips.pjmsn.me.uk/t0003.htm
You probably need to try the "DDE" method mentioned near the top.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"EmilyR" wrote in message
...
I've had a problem with mail merging data from Excel into Word. It'll
take
over some of the data but can leave part of the information off. I have
just
come to the conclusion that this is because it will only take 255
characters
from a particular Excel cell to Word.
Can anyone help in either extending the amount of characters or some other
way to fix it??
Thanks in advance
Emily