Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2007

Tip: Looking for answers? Try searching our database.

MergeField

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeff Bergeron - 22 Feb 2007 03:22 GMT
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 the field is a
memo and include more characters than 255. But, into Word, only 255 first
characters are shown.

Thank you!

Jeff
Peter Jamieson - 22 Feb 2007 08:59 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.