Mail merge error in 07 but not in 03?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kanex125 - 09 Apr 2008 19:35 GMT

I am getting a Run-time error '9105': string is longer then 255 charactars,
when running a macro in word 2007 but the same macro runs fine in word 2003.
Suggestions? The code is
ActiveDocument.MailMerge.OpenDataSource Name:= _
"S:\cco\staff\CCOSHARE\DISASTER RECOVERY\4 DR PLANNING\Replicator
MASTER CURT\DR PLAN QUESTIONNAIRE INPUT MASTER V1.xls" _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data
Source=S:\cco\staff\CCOSHARE\DISASTER RECOVERY\4 DR PLANNING\Replicator
MASTER CURT\DR PLAN QUESTIONNAIRE INPUT MASTER V1.xls;Mode=Read;Extended
Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System datab" _
, SQLStatement:="SELECT * FROM `'Merge Info - Questionnaire$'`", _
SQLStatement1:="", SubType:=wdMergeSubTypeAccess

Reply to this Message

Doug Robbins - Word MVP - 09 Apr 2008 20:41 GMT

Delete all of the unused attributes and those that are set to the default
value, leaving only the comma separators to reduce the length of the connect
string.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am getting a Run-time error '9105': string is longer then 255 charactars,
> when running a macro in word 2007 but the same macro runs fine in word
[quoted text clipped - 15 lines]
> , SQLStatement:="SELECT * FROM `'Merge Info - Questionnaire$'`", _
> SQLStatement1:="", SubType:=wdMergeSubTypeAccess

Reply to this Message