Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Error | Mailmerge | |||
Odd Mail Merge error | New Users | |||
e-mail addresses for Word mail merge have format error | Mailmerge | |||
Mail Merge Error | Mailmerge | |||
Mail Merge Error | Mailmerge |