Note that the message was cross-posted to three NGs, two of which are for
Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Shane Devenshire" wrote in
message ...
Hi,

You might get a more satisfactory answer in one of the Word newsgroups,
just
a thought,

Cheers,
Shane Devenshire

"Greg" wrote:

Hi,

I am working on a project which requires mail merging an Excel
spreadsheet with several fields that contain more than 255 characters.
I am using Word 2003 on an XP machine. The results from these merge
fields are truncated. I found a workaround for this problem in the
online Microsoft Word Support file, WD2000: Field Text Truncated When
Merging or Inserting Database. It recommended I use Dynamic Data
Exchange (DDE) instead of Open Database Connectivity (ODBC). However,
this workaround doesn't solve my problem, the fields remain
truncated.

Are there any other alternatives to resolve this problem? It seems
converting my data to CSV or Tab delimited causes the data to be
truncated as well. I remember reading somewhere that I could convert
my Excel spreadsheet to an Access database which doesn't care about
this 255 character limitation. However, I didn't have much success
importing these fields in Access.

Thanks in advance for any assistance you can provide.

Regards,
Greg