When merging to Word, some info from cell missing?

[EmilyR]

Have a document in excel that I'm using Mail Merge to merge it into Word.
When a cell is merged over to Word, it only takes half the infomation from
that cell. Is there any way to get the rest of the information? Is there a
certain number of words or letters that the merged cell is restricted to?

 

[Dave Peterson]

Just a guess...

Is the length of the text brought over in the mailmerge about 255 characters?
If yes, then I think you hit a restriction in the way windows passes information
between applications.

I don't know a pretty way around it.

Maybe you can use multiple cells in excel????

 

[EmilyR]

thanks for your response Dave,
yeah i've come to that conclusion after 6 hrs!! is there no way to extend
the amount of characters it'll accept?

 

[Dave Peterson]

Not that I know--maybe someone else has a workaround.

The same thing happens when you try to retrieve a value from a closed workbook
in excel. But if you open that other (sending) workbook, then excel can get all
the data.

I'm not sure that there is a workaround like this between applications--but you
may want to try that.

 

[EmilyR]

ok thanks very much for your help & time Dave, i'll give that a try

 

[Henk57]

ok thanks very much for your help & time Dave, i'll give that a try

:
-
Not that I know--maybe someone else has a workaround.

The same thing happens when you try to retrieve a value from a close
workbook
in excel. But if you open that other (sending) workbook, then exce
can get all
the data.

I'm not sure that there is a workaround like this betwee
applications--but you
may want to try that.



EmilyR wrote:-

thanks for your response Dave,
yeah i've come to that conclusion after 6 hrs!! is there no way t
extend
the amount of characters it'll accept?

:
-
Just a guess...

Is the length of the text brought over in the mailmerge about 25
characters?
If yes, then I think you hit a restriction in the way windows passe
information
between applications.

I don't know a pretty way around it.

Maybe you can use multiple cells in excel????

EmilyR wrote:

Have a document in excel that I'm using Mail Merge to merge it int
Word.
When a cell is merged over to Word, it only takes half th
infomation from
that cell. Is there any way to get the rest of the information? I
there a
certain number of words or letters that the merged cell i
restricted to?

Excel has a limit of 255 characters in a cell, indeed. But is thi
full cell content variable for your mailing? If not, make the bod
text in Word, and insert fields (linked to Excel cells) where you nee
customization. Note that you can link as unformatted text so the tex
format in Word overrides the Excel format. For further help you ma
wish to post in the Word forum - there is a Mail Merge subject

 

[Dave Peterson]

Excel95 had a limit of 255 characters in a cell. xl97+ supports up to 32k
characters per cell.

 

[Dave Peterson]

Maybe you can split the text into multiple cells and retrieve each of those
cells????

ok thanks very much for your help & time Dave, i'll give that a try

 

[Henk57]

Maybe you can split the text into multiple cells and retrieve each o
those
cells????

EmilyR wrote:-

ok thanks very much for your help & time Dave, i'll give that a try

:
-
Not that I know--maybe someone else has a workaround.

The same thing happens when you try to retrieve a value from a close
workbook
in excel. But if you open that other (sending) workbook, then exce
can get all
the data.

I'm not sure that there is a workaround like this betwee
applications--but you
may want to try that.



EmilyR wrote:-

thanks for your response Dave,
yeah i've come to that conclusion after 6 hrs!! is there no way t
extend
the amount of characters it'll accept?

:

Just a guess...

Is the length of the text brought over in the mailmerge about 25
characters?
If yes, then I think you hit a restriction in the way window
passes information
between applications.

I don't know a pretty way around it.

Maybe you can use multiple cells in excel????

EmilyR wrote:

Have a document in excel that I'm using Mail Merge to merge i
into Word.
When a cell is merged over to Word, it only takes half th
infomation from
that cell. Is there any way to get the rest of the information
Is there a
certain number of words or letters that the merged cell i
restricted to?

Thanks Dave for explaining. The col width has a 255 chars limit an
without wrapping ...

 

[Dave Peterson]

According to excel's help:

That 255 number limi you see in Format|column|width is:

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.

You'll be able to see lots more that 255 I's in a single line of a cell with a
width of 255--I saw about 447 I's with an Arial 10 point font.

(Yeah, I have wayyyyyy too much time on my hands!)


Henk57 wrote:

 

[EmilyR]

yes Dave you have too much time, did u actually count all of the I's?? haha

I tried to have the Excel spreadsheet open when opening the word document,
which came up with an error in finding excel doc at first, but i tried it
again and it just worked the same.

Thanks for your help, I'm going to look through a few things to see if the
characters can be expanded. If not then I guess I'll be splitting it into 2
cells.

Have a great Christmas

 

[Dave Peterson]

I used
=rept("i",255)
then increased that 255 to fill A1 (at its widest)
(But thanks for agreeing!!!)

That's what I would have thought (about the mailmerg), but I was too lazy to try
it <vbg>.

yes Dave you have too much time, did u actually count all of the I's?? haha

I tried to have the Excel spreadsheet open when opening the word document,
which came up with an error in finding excel doc at first, but i tried it
again and it just worked the same.

Thanks for your help, I'm going to look through a few things to see if the
characters can be expanded. If not then I guess I'll be splitting it into 2
cells.

Have a great Christmas