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

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