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?

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

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

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" wrote:

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

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

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

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" wrote:

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

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


--

Dave Peterson

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

"Dave Peterson" wrote:

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

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" wrote:

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

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


--

Dave Peterson

EmilyR;2543411 Wrote:
ok thanks very much for your help & time Dave, i'll give that a try

"Dave Peterson" wrote:
-
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 wrote:-

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" wrote:
-
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 wrote:

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

--

Dave Peterson
-

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




--
Henk57

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



Henk57 wrote:

<<snipped

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

--
Henk57

--

Dave Peterson

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

EmilyR wrote:

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

"Dave Peterson" wrote:

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

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" wrote:

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

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


--

Dave Peterson


--

Dave Peterson

Dave Peterson;2543615 Wrote:
Maybe you can split the text into multiple cells and retrieve each of
those
cells????

EmilyR wrote:-

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

"Dave Peterson" wrote:
-
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 wrote:-

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" wrote:

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

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
-

--

Dave Peterson
--

--

Dave Peterson

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




--
Henk57

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

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

--
Henk57

--

Dave Peterson

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" wrote:

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

EmilyR wrote:

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

"Dave Peterson" wrote:

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

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" wrote:

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

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


--

Dave Peterson


--

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.

EmilyR wrote:

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" wrote:

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

EmilyR wrote:

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

"Dave Peterson" wrote:

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

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" wrote:

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

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


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson