[kanex125]

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="""";Us er 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

[Doug Robbins - Word MVP]

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.

--
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

"kanex125" wrote in message
...
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="""";Us er 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