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