<Buffer for return string is too small>
in [Word VBA]
|
From: PhilEngle on 26 Apr 2006 12:33 When I try to refer to the following phrase in my VBA macro in Word 2002: ActiveDocument.MailMerge.DataSource.ConnectString I get the following error: <Buffer for return string is too small> (This MAY be error 9121 and there MAY be a 500-character limit to the buffer.) Any suggestions as to how this "showstopper" error might be solved? Thank you!
From: Cindy M -WordMVP- on 1 May 2006 07:51 Hi =?Utf-8?B?UGhpbEVuZ2xl?=, > When I try to refer to the following phrase in my VBA macro in Word 2002: > > ActiveDocument.MailMerge.DataSource.ConnectString > > I get the following error: > > <Buffer for return string is too small> > > (This MAY be error 9121 and there MAY be a 500-character limit to the buffer.) > > Any suggestions as to how this "showstopper" error might be solved? > Word 2002... What's the data source, and what string are you trying to use for this property? Remark: Word 2002 switched to a default OLE DB connection method. The connection strings tend to be very long, sometime too long for Word (mail merge stuff was designed a long time ago). Mail merge stuff tends to have a 256 or 512 character limit for string arguments. My advice would be to use an ODBC connection to the data, if at all possible. Otherwise, you need to edit the OLE DB string to just the essentials required for the connection. 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 :-)
|
Pages: 1 Prev: finding text wherever it appears in a word document Next: Languages |