Hi Robert,
> When merging comments from an Excel spreadsheet (also happens with same
> comments in Access database) noticed that the longer strings were being cut
> off in mid word. I would guess there is a limit to the length of the string
> that can be merged? Is it 255 characters or what?
Yep.
> Is there any way to solve this one without having to paste into Word?
You need to connect using a different method, probably. Version of Word?
> Another issue is when spreadsheet contains a "mixture" of strings and
> numbers. There was no problem with the merge "per se" - no error message
> etc, but only the numbers were merged - the strings were simply " ignored"
> as far as I can see.
Again, version of Word?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)