View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
kanex125 kanex125 is offline
external usenet poster
 
Posts: 1
Default Mail merge error in 07 but not in 03?

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