View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge error in 07 but not in 03?

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