1. Is it stopping at 255 using DDE?
2. (I'm assuming that you have the space on the label to fit those 255
characters :-) )
3. Are you in a position to decide what mail merge data source you start
with? If you only have a small number of columns in Excel (less than around
64) you should be able to copy/paste your Excel data into a new Word
document and use that as the data source.
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.
Why does doing two merges make a difference?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"EmilyR" wrote in message
...
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