<Buffer for return string is too small>

[PhilEngle]

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!

 

[Cindy M -WordMVP-]

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