There has been a recent conversation on this topic - see
http://groups.google.co.uk/group/microsoft.public.word.mailmerge.fields/browse_f
rm/thread/f877ab6c115da8e3/894cb8508515a02a?lnk=st&q=&rnum=1#894cb8508515a02a
(You may need to reconstitute the link)
Which connection method are you using to connect to Access (if you don't
know, it's probably OLE DB)? Can you try the other methods (check Word
Tools|Options|General|"Confirm conversions at open", go through the process
of connecting to your data source again, and choose DDE, ODBC or OLEDB)?
Are you connecting to a Query or a Table?
Experiments here with up-to-date versions of Word 2003, Access 2003, and an
Access 2000 format database suggest that all connection methods (the
default, OLE DB, ODBC, and the old Word 2000 default, DDE) read memos
considerably longer than 255 characters, but that DDE fails altogether with
records with long memo fields. But it is obvious that other people are
experiencing something different.
Peter Jamieson
> Hi! Is someone know how to obtain more than 255 characters into a
> mergefield in Word 2003? My data are into an Access database and one of
[quoted text clipped - 4 lines]
>
> Jeff
Jeff Bergeron - 22 Feb 2007 15:19 GMT
Thank you for the quick answer. I connect to a table. In fact, the process start
with a "table creation query", But I just found the error. The "table creation
query" cut the memo field! I trid to connect directly to a select query but Word
told me that's impossible to connect. I'm working on it.
So thankss and I will post an update!
Jeff
> There has been a recent conversation on this topic - see
> http://groups.google.co.uk/group/microsoft.public.word.mailmerge.fields/browse_f
rm/thread/f877ab6c115da8e3/894cb8508515a02a?
lnk=st&q=&rnum=1#894cb8508515a02a
> (You may need to reconstitute the link)
>
[quoted text clipped - 22 lines]
>>
>> Jeff